View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Checking for security level to allow macros to run

Hi Klaus

You can hide all sheets exept one
On that sheet you put a messege like "you must eneble macro's to work with this workbook"

Then in the workbook open event unhide the sheets and in the before save event hide them


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Klaus" wrote in message ...
Is there any way to check programmatically, if the security level is set to
allow macros to run, and then 1) display a message indicating that the
security level must be set to medium and/or the macros must be enabled; and
2) stop any activity on the workbook and force the user to restart excel with
macros enabled?