Dear All

Does anyone know how to prevent a workbook from opening if the user
chooses to disable macros? (eg they have the Security Level set to
'high').

I want to use code to provide certain protections to spreadsheets (for
example, to ensure that users can't copy and paste data). But if the
user opens without enabling macros, they can bypass these extra
protections.

I have thought of one way:
Upon saving, hide all sheets except for one sheet with a message on it
"In order to use this spreadsheet, you must enable macros". Upon
opening, code unhides the other spreadsheets and hides the first sheet.
When combined with Protect Workbook Structure this works, kind of.
But it's pretty clumsy and looks a bit confusing to the user (they get
a brief period of time to read the first sheet when the book loads).

Cheers
Richard