disable workbook

R

Roxy

I would like to not allow a user to open a workbook if she/he does not enable
macros when prompted. Is there a cool way to do this? I have some code in
the Workbook_Open that must run when the workbook is open. Thanks.
 
J

john

the common way most deal with this problem is to hide all but one sheet when
saving & closing your workbook. This sheet would be displayed when macro's
are not enabled next time workbook is opened, showing a message informing
user that macro's must be enabled.
If however, macros are enabled then other worksheets are unhidden & message
sheet hidden.
Sounds tad complicated but can be made to work for most uses.
Have a look at this site for some idea how to approach the problem. You can
google other sites for further samples
http://www.dotxls.com/excel-security/28/how-to-make-a-user-enable-excel-macros

Hope helpful
 
Top