VBA Codes Used: - Macro-Enabled Excel 2010 file with multiple checkboxes on sheet1 (Form) that will unhide rows on sheet2 (Questions), code saved directly in Sheet1 in VBA;
- 1 "Reset" button on sheet1 (Form) to uncheck all checkboxes, the code is set as a module and assigned to button;
- 1 "Unhide/Hide" button on sheet2 (Questions) that unhides or hides all rows when clicked, the code is set as a module and assigned to button.
Situation: My office works on a shared network, we have a sharefile folder that I upload the excel document to for multiple users to access when needed. The only time the document is edited is when the questions on sheet2 (Questions) change or when text is added/deleted. When that happens I rework the VBA code to match the checkboxes to the specified questions, save document. Everything was working just fine for almost an entire year until recently the codes stopped working for everyone except me. Everyone enables their computers to run the macros but suddenly some people recieve a runtime error when clicking the buttons or nothing happening at all when the checkboxes are checked. Other people can't even click in the document as everything acts as if it is locked.
Older documents with old questions work fine for everyone. No errors, same code. I thought maybe the document was corrupted so I created a brand new macro-enabled document and hand wrote all the questions all over again and recoded everything. Same errors for everyone EXCEPT me. I am not saving to a personal file, I am not doing anything different than before. All users have Excel 2010 and make sure their macros are enabled when opening document. They tried saving the document to their desktops and opening it, same issue.
Test Document with same codes used:
TestBook.xlsm
Sheet1 (Form) VBA Code Used:
Module1 used to Reset checkboxes with button on sheet1:
Module2 used to unhide/hide with button on sheet2:
I have no idea what is going on. I feel like I have tried everything. I am still in the beginning stages of understanding VBA and Macros so can anyone help me out with this issue I am having? Why does everything work perfectly for me, but no one else? Why did it work before for everyone, but not now? I'm at a loss here.
Bookmarks