Excel 2007 VBA prevent workbook use with macros disabled
Posted on 2012-03-23
Does anyone have any good ideas to stop use of a workbook when macros are disabled? I have some code in the Worksheet_Change and WorkSheet_SelectionChange that stops users inadvertently changing certain things. I can't use protection for this some data is in a table and if the cells are protected the users can't sort and filter.
If they disable macros when the worbook opens they'll be able to change everything. I thought of something like making the key sheets hidden and only unhiding them in Workbook_Open code, then hiding again when they close. But if they start up, do some work, save, do some more work then close without saving changes, the sheets won't be hidden next time they open.
This does not need to be high security - it's just to stop accidental changes. Any ideas?