I created a small macro to copy new inputs to the end of a row of cells. The issue that I should've seen coming was that the last row where data was being pasted was in the range being watched, so Excel infinite-loop crashed. When I reopened the workbook the macro didn't respond to changes to the cells it watched, so I tried to run another macro from the VBA editor, but got an error pop-up (attached below). When I tried to go to the settings to allow macros, the options were all grayed out.
What I've tried, and things to know:
I did change the code to avoid the infinite loop.
I sent the file to a coworker who was able to open it and saw the code executing as expected.
I restarted my PC, and the options are still grayed out.
I had the coworker send the file back to me; I downloaded it and opened it, but I got the same error pop-up and the options were still grayed out.
I'm running office 365 on Windows 10 Enterprise.
I've contacted my company's IT, but I don't know how long it'll take them to respond.
What I've tried, and things to know:
I did change the code to avoid the infinite loop.
I sent the file to a coworker who was able to open it and saw the code executing as expected.
I restarted my PC, and the options are still grayed out.
I had the coworker send the file back to me; I downloaded it and opened it, but I got the same error pop-up and the options were still grayed out.
I'm running office 365 on Windows 10 Enterprise.
I've contacted my company's IT, but I don't know how long it'll take them to respond.
Attachments
Last edited by a moderator:
