G
Guest
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.
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.