Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet which activates a VB Code when the user selects "enable
macros" from the prompt box at startup. To enter information into the active cells, we must "disable macros" from the prompt box at startup. Once the user has entered and saved information into the active cells, the user must exit the program, reenter the program and select "enable macros" to activate the VB Code. On the worksheet "Winner Photo Log", I would like to insert a macro so that, when the user clicks cell E6, the VB Code will activate (i.e. "enable macros"). This will eliminate the step of exiting and reentering the program. Thanks in advance for any help you may be able offer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
activate macro | Excel Discussion (Misc queries) | |||
Run Code On Activate | Excel Worksheet Functions | |||
what is code to activate a combo box in control toolbox | Excel Discussion (Misc queries) | |||
How to activate "New" tab in Dataform through VB Code | Excel Discussion (Misc queries) | |||
Is it possible to activate a txt document in excel code? | Excel Programming |