Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Enable/Disable Macro message at startup
I hope someone can help.
I have an excel workbook that contains many hidden worksheets. There is one unhidden worksheet, on which there are individual items listed. Whenever a person choose an item, the will have to put in a password. The password will determine which worksheet is opened. Problem: Whenever I try to open the workbook, the messagebox appear asking if I want to enable/disable macros. Solution foreseen: I want to use some code to enable the macro even without the person seeing this messagebox. I also want to use some code to disable the macro whenever the person close the workbook. How to perform solution : ??? Can anyone assist me with this? Thanks much. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Enable/Disable Macro message at startup
I want to use some code to enable the macro even without the person
seeing this messagebox That's not possible. The point is to protect users from "malicious code". If an evil doer could force his code to run there would not be any protection. -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro Pop-Up | Excel Discussion (Misc queries) | |||
disable 'enable macros' pop-up message on all computers | Excel Discussion (Misc queries) | |||
Disable/Enable Macros Message box in Excel2007 | Excel Discussion (Misc queries) | |||
Bypassing ENABLE/DISABLE MACROS message | Excel Discussion (Misc queries) | |||
macro disable and enable. | Excel Programming |