rrenis
02-26-2009, 07:51 AM
Hi - does anyone know of a way in MS Project to alter the view on shut down so that a custom message is left notifying a user opening the Project that Macro's need to be enabled?
In excel I have a some code which will hide all of the sheets except for one when it closes. If the spreadsheet is then opened and the Macros are turned off the spreadsheet appears unusable, forcing the user to enable macros to unhide the relevant sheets as it opens.
Ideally a solution similar to that outlined above that I employ in excel would be great but I can't see that it can be acheived in MS Project. :think:
Just wondered if anyone has managed something similar - or has any ideas? :help
Thanks for looking.
Cheers,
rrenis
In excel I have a some code which will hide all of the sheets except for one when it closes. If the spreadsheet is then opened and the Macros are turned off the spreadsheet appears unusable, forcing the user to enable macros to unhide the relevant sheets as it opens.
Ideally a solution similar to that outlined above that I employ in excel would be great but I can't see that it can be acheived in MS Project. :think:
Just wondered if anyone has managed something similar - or has any ideas? :help
Thanks for looking.
Cheers,
rrenis