I have a file with VBA code and a Forms Button that starts a macro. I also have a drop-down data validation list throughout a range of cells.
Several people use this file one at a time (no sharing).
However, the file is getting corrupted on their ends constantly whereby the data validation drop-down list disappears (not even the little arrow appears (althought the Input Message box is still there). AND, the forms button just disappears.
All the VBA code remains in tact.
Any ideas what is causing this sever error?