View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Libby Libby is offline
external usenet poster
 
Posts: 151
Default 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