By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,312 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,312 IT Pros & Developers. It's quick & easy.

Automation Excel 'disable macro' prompt

P: n/a
How do I answer the disable macro prompt automatically when opening an Excel
workbook? We are using Excel 97 and 2002. In 2002 we want the Medium
security (prompt user) to safeguard against e-mail attachments... but our
..NET app needs to open as Read-Only and Disable Macros at all times. Is
there a way to answer these questions programatically before opening the
workbook?

I'm also looking for any good references on the Excel object model, as we
dont have any.
Thx,
troy
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 9 Aug 2004 15:47:01 -0700, "Troy" <Tr**@discussions.microsoft.com> wrote:

How do I answer the disable macro prompt automatically when opening an Excel
workbook? We are using Excel 97 and 2002. In 2002 we want the Medium
security (prompt user) to safeguard against e-mail attachments... but our
.NET app needs to open as Read-Only and Disable Macros at all times. Is
there a way to answer these questions programatically before opening the
workbook?

No. You can change your Security Level to Low which will eliminate the warning dialog. The only
other alternative is to digitally sign your Excel documents.

I'm also looking for any good references on the Excel object model, as we
dont have any.

See if the following helps:

Understanding the Excel Object Model from a .NET Developer's Perspective
http://msdn.microsoft.com/library/de...l/ExcelObj.asp
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.