My excel file is on a shared drive and has macros. If the user does not select "enable macros" when he opens the file, I want a message box to pop-up saying "You must click enable macroe for this file to work properly, close this file and re-open". Is this possible, or is there a better way of making sure the users clicks enable macros?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Enabling Macros
- Thread starter tphillips
- Start date
See this thread
http://www.mrexcel.com/board2/viewtopic.php?t=103551&highlight=enable+macro+open+hide
Peter
http://www.mrexcel.com/board2/viewtopic.php?t=103551&highlight=enable+macro+open+hide
Peter
Upvote
0
Justinlabenne
Well-known Member
- Joined
- Jun 12, 2004
- Messages
- 957
Upvote
0
Joe Was
MrExcel MVP
- Joined
- Feb 19, 2002
- Messages
- 7,539
The code to do this will also be removed, so a work-around is to set an event to select a common cell each time the application is saved and closed and for you to to save the workbook with that cell location saved.
Then for that cell use: Data - Validation - InPut Message to add an opening comment for the user. This way you can warn the user even if the macros are disabled!
I use:
"Excel does no actual virus checking it uses psudo-virus checking. Any found code if flaged as "possibly" containing a virus. To run this application you must enable macros! Exit and re-open this application!"
Then for that cell use: Data - Validation - InPut Message to add an opening comment for the user. This way you can warn the user even if the macros are disabled!
I use:
"Excel does no actual virus checking it uses psudo-virus checking. Any found code if flaged as "possibly" containing a virus. To run this application you must enable macros! Exit and re-open this application!"
Upvote
0
Similar threads
- Solved
