Saving blocked

[S Oberlander]

I have a beforeclose event to block saving changes, however if the user doesn't enable macros they are still able to save!
Is there any way around this?

 

[Joe4]

You cannot "force" VBA to be enabled, however, you can make it strongly encouraged.
What I have seen some people to do is hide all the data and worksheets, and have a "Workbook_Open" event unhide it when the file is opened.
So, if VBA is not enabled, the "Workbook_Open" code will not run, and they will not see any data.

A non-VBA option would be to make your file read-only.

 

[S Oberlander]

So, if VBA is not enabled, the "Workbook_Open" code will not run, and they will not see any data.

Thats a brilliant idea! I can use this in more then one instance!