prevent workbook from open if user does not enable macro

[maacmaac]

Is there a way to force a user to enable macros to open a workbook? I did try writing a piece of code that what close the workbook if they disabled macros but realized it wouldn't work if macros are disabled. Thanks in advance for any comments.

[Whizbang]

Create a sheet that says "You must enable macros to open this workbook", followed by instructions on enabling macros. Then you hide all sheets except the instruction sheet. Then you can protect the workbook structure with a password.

In your Workbook Open event, you unprotect the workbook and unhide the desired sheets and hide the instruction sheet. Just make sure to add a routine to do the opposite in the workbook close event.