Excel Enable Macro message

  • Thread starter Thread starter Worsty
  • Start date Start date
W

Worsty

Could someone please give me the code to automatically enable Macros i
Excel so that the user doesn't get the prompt when opening th
workbook?

Thanks
 
Hi
you can't do this, if the user opens the workbook manually. The only
way would be to set the security level to 'low' but I wouldn't
recommend this.
 
Worsty

If a virus writer could use code to defeat the warning there wouldn't be much
point in having a warning.

Check Help Answer Wizard "digital certificate"(no quotes) to learn how to
digitally sign a workbook as a "trusted source".

Gord Dibben Excel MVP
 
This is not a direct answer to your question but:

You could also move your macros to a single spreadsheet
and turn it into an Add-in (.XLA) file. Spreadsheets
that use the macros from the XLA files don't flag as security
problems. They are also easier to maintain since the code
is in one place rather than many. You must add the add-in
though via Tools->Add-Ins.
 
Back
Top