Forum Discussion
VBA events stop working for one user when another user opens the shared workbook
Hi,
I’m experiencing a strange issue with VBA in Excel.
We use several Excel files as a CRM system, all with VBA (mainly worksheet events). The files are shared so that my employee and I can work on them.
Recently, VBA events stopped working only on my computer in some of the files.
Important observations:
For my employee, everything works normally.
Manual macros run correctly on my machine.
Worksheet events (like Worksheet_Change) do not fire.
Application.EnableEvents returns True.
Macro security and Trusted Locations are already configured.
The files are almost identical (same structure and VBA code).
What makes it even stranger:
A file that worked for me yesterday stopped working today immediately after my employee opened it.
Since then, the VBA events no longer trigger on my computer in that file, while they still work perfectly for him.
So it seems that when another user opens the shared workbook, VBA events stop working only on my machine.
Has anyone seen something like this before?
Thanks.