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/de.../odc_dsvba.asp
Code Signing Office XP Visual Basic for Applications Macro Projects

http://support.microsoft.com/default...;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/de...tml/combat.asp

Another reference:
http://msdn.microsoft.com/library/en...vbaproject.asp


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


http://office.microsoft.com/assistan...ustworthy.aspx
How to Tell if Digital Certificate Is Trustworthy in Office XP
--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
No, the user is always given the option to disable macros for their own
protection (if they have set that level of security) unless they have
previously selected to run the macros by enabling an addin or placing the
file in the xlstart directory.

--
Regards,
Tom Ogilvy


"DEL" wrote in message
...
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.

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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).

--
Regards,
Tom Ogilvy

"ripclaw" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/