If you don't enable macros, I won't show you my workbook..

[TEAM]

Does anyone have a creative idea for preventing a user from using a workbook unless macros are enabled? Is there a way to set up a code that reveals all information in a workbook....in other words, if macros are enabled, then the workbook will be revealed! Otherwise, you see a page that just says to start over again and enable macros the next time.


You get the idea. Great, thanks!

[swatsp0p]

Have code that HIDE the sheets (xlveryhidden) as Private Sub Workbook_BeforeClose(Cancel As Boolean). Have code that unhides the sheets when opened as Private Sub Workbook_Open(). If macros are disabled, the sheets will be hidden. Leave only one sheet unhidden that warns the user to close/reopen with macros enabled (maybe code this sheet to be hidden when opened)

HTH

Bruce

[TEAM]

Ahh, good idea. I should be able to get the code right for that.

Thanks!