Sandra Frongillo
asked on
Excel 2013 Macro to force enable macros each time workbook is opened (.xlsb or .xlsm)
Looking for a Excel 2013 macro for an .xlsb and .xlsm workbooks that will hide all sheets and force user to enable macros every time they open they open the workbook so they can see the hidden pages.
I have an example at home, but here's a good article by Chip Pearson
ASKER
I tried that code but it keeps bugging out here:
ThisWorkbook.Worksheets(C_ INTRO_SHEE TNAME).Vis ible = xlSheetVisible
ThisWorkbook.Worksheets(C_
ASKER
Then when I reopen the macro bugs out here:
Private Sub Workbook_Open()
Private Sub Workbook_Open()
Can you post your workbook. I'll post my example when I get home if I can't fix yours
ASKER
Here's the test file I was using
TEST.xlsm
TEST.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That works!!! Thanks!!!
ASKER
THAT's AWESOME!!! Thanks a million !!!
Pleased to help.