Unable to set the Display Alerts property of the application class

[PhilM]

I have an Excel spreadsheet accessed via a company intranet. I am
experiencing the above error when tying to turn off display alerts via
VBA. Can anyone help?

 

[NickHK]

Never seen that one. Maybe this ?
http://support.quickbooks.intuit.com/archive/faqs/pos02/b1e9c8a.html

Otherwise, show your code.

NickHK

 

[PhilM]

Never seen that one. Maybe this ?http://support.quickbooks.intuit.com/archive/faqs/pos02/b1e9c8a.html

Otherwise, show your code.

NickHK






- Show quoted text -

Hi Nick

Its generating at this code

ThisWorkbook.Parent.DisplayAlerts = False
ThisWorkbook.Parent.ScreenUpdating = False

 

[NickHK]

If that link does not apply, are you opening the WB in a browser ?

NickHK

 

[PhilM]

If that link does not apply, are you opening the WB in a browser ?

NickHK







- Show quoted text -

Yes. The code works fine when run as a WB in Excel. I need to get it
working when called via hyperlink in IE6 so companywide staff can use
it.

 

[NickHK]

Well that's probably your problem then.

In the words of Dave Peterson:
"This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened
in a browser."

NickHK

 

[PhilM]

Well that's probably your problem then.

In the words of Dave Peterson:
"This may not be a good solution for you...

I'd do my best to not let MSIE open the file:

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorerhttp://support.microsoft.com/?scid=162059

There are just too many things that don't work when an excel file is opened
in a browser."

NickHK

- Show quoted text -

Cheers Nick,

Forcing it to open in Excel is the way!