I'm not sure how I can use this technique to check for the security level.
Klaus

"Ron de Bruin" wrote:

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?