You add a sheet to the workbook with a message "If you have disabled macros,
this workbook is useless" or similarly frightening.

In Before_Close sub you xlveryhidden all the sheets but that one.

If users open the workbook with macros disabled, this is all they will see.

If macros are enabled, your Workbook_Open code will unhide the other sheets and
hide the message sheet and your Before_Save code will be enabled also.


Gord



On Thu, 29 Jun 2006 07:06:15 -0500, mhart210
wrote:


Thank you for the tip, of course you have peaked my interest in the
disabling of the worksheet. Would I use deactivate for this?