Enable Macros with No Prompt

[Beau]

Hello,
How do you select "Enable Macros" when Excel starts
without prompting the user? I'm a little new to Excel
programming. I don't want to give the user the option.
Thanks.

Beau

 

[Tom Ogilvy]

The user is always given the option to enable or disable macros if they have
chosen the appropriate security level. This is for their self protection as
their is no way to know if a macro is harmful or not. You can not overcome
this prompt with code contained in the workbook where you don't want the
prompt (in fact the prompt is given before any code is run). Think about
it. If it could be turned of by code, then there really would be no reason
to have the prompt.

 

[Tom Ogilvy]

For completeness, you can certify your code and if the user accepts you as a
trusted source, then the prompt will not be rendered for further openings
(xl2000 and later).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q288985
XL2002: About Digital Signatures in Excel Workbooks


http://support.microsoft.com/?KBID=206637
OFF2000: Overview of Digital Certificates (Q206637)

http://support.microsoft.com/?KBID=217221
OFF2000: Using SelfCert to Create a Digital Certificate for VBA Projects
(Q217221)



An Overview:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnimo00/html/combat.asp

Another reference:
http://msdn.microsoft.com/library/en-us/odeopg/html/deovrsigningvbaproject.asp



http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329228
OFFXP: How to Make Sure That Your Office Document Has a Valid Digital
Signature


http://office.microsoft.com/assistance/2002/articles/otelldigitalcertiftrustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP