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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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'
 
Back
Top