Enable/Disable Macro
 

Is there a way to stop the message to enable or disable macros from appearing
when opening a workbook that has macros.

Thanks,
Les

Enable/Disable Macro
 

Tools Options Security Macro Security... low
--
Gary''s Student - gsnu200772

Enable/Disable Macro
 

Setting the macro security to Low enables all macros; setting it to High
disables all macros. Either way you don't get the enable/disable message.

However, if you want to retain macro security but get rid of the message,
then you could digitally sign them. In the VBA enditor ToolsDigital
Signature.

Users can then add you as a trusted source and the macros will automatically
run.

"WLMPilot" wrote:

Is there a way to stop the message to enable or disable macros from appearing
when opening a workbook that has macros.

Thanks,
Les