disable macro button in warning box - how to do the coding

G

Guest

when user click disable macro for medium security, i want to hide all sheets except 1 dummy sheet saying need to enable macro only can see all the sheet. how to do the coding from user click on the disable macro button in dialog box?
pls help
 
F

Frank Kabel

Hi
I would do it the other way round:
- create your sheet so that without any macros it would show this
'dummy sheet'
- Within the work_book open event place some code to hide this 'Dummy
Sheet' and to unhide all other sheets
- You may also add some code in the workbook_close event to hide all
sheets again and unhide the 'Dummy sheet'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top