auto turn off macro virus protection

  • Thread starter Thread starter DEL
  • Start date Start date
D

DEL

Can i turn off the window prompt to run macros from a
Workbook_Open()command. The reason for this is i am
opening an excel file from a web page and all toolbars are
dissabled through a Workbook_Open()command. This is to
limit the user from printing, saving or basically doing
anything to the file. The problem arises due to a prompt
to enable or disable the macro. Is there a command line to
dissable this prompt.
 
for completeness, information on certification (available for 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
 
Tom

SO what you're saying is there's no way you can turn off that box that
pops up when you open a workbook containing macros?

thanks
 
Unless you certify your code (in xl2000 or later) and the user accepts you
as a trusted source.

You can also put your code in an addin and the user selects to load the
addin

Or you can locate the file in the xlStart directory.

but in general, there is no way to turn of the box that pops up (of course
in xl2002, if security is set as high, then uncertified macros are disabled
without prompt).
 
Back
Top