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

--
Message posted from http://www.ExcelForum.com

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.


--
Regards
Frank Kabel
Frankfurt, Germany
"Worsty " schrieb im
Newsbeitrag ...
Could someone please give me the code to automatically enable Macros
in
Excel so that the user doesn't get the prompt when opening the
workbook?

Thanks,


---
Message posted from http://www.ExcelForum.com/

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

On Wed, 3 Mar 2004 11:36:58 -0600, Worsty
wrote:

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

Thanks,


---
Message posted from http://www.ExcelForum.com/

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.



"Worsty " wrote in message ...
Could someone please give me the code to automatically enable Macros in
Excel so that the user doesn't get the prompt when opening the
workbook?

Thanks,


---
Message posted from http://www.ExcelForum.com/