View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Enable Macros by Code

Hi,

No, you can't enable macros by code. If security is set to medium or higher
then it's a user choice whether macros are enabled or not.

Mike

"aftamath77" wrote:

Is there code I can put in visual basic that will enable all macros when the
workbook opens, so there is no need to click the options for enable macros.

I know how to enable macros in the Trust Center, I would like to enable by
code.