Forum Discussion
Pete256
Nov 09, 2024Copper Contributor
Excel runs a VBA macro every time I modify a cell
I'm having an issue with Office 365 for Enterprise in which any time I modify a cell in Excel, one of my VBA macros is called, and calls out an error because the worksheet I'm working with doesn't co...
NikolinoDE
Nov 09, 2024Platinum Contributor
Without a file or the VBA code to generate or look for the error, it is not possible to provide a reasonable solution.
If the macro requires a password and you don't have it, it might indicate that you don't have full access to modify or disable the problematic macro. If you can’t access the macro:
Check with the author of the macro or your IT department to obtain the password or have the macro modified.
Create a copy of the workbook and remove all macros from the copy (use File > Save As, and save as an .xlsx file instead of a macro-enabled .xlsm file) to work without triggering the macro.
Otherwise it would be beneficial to add a little more information, as described above.
Thank you for your understanding