On 29 Jun, 11:29, "NickHK" wrote:
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

"PhilM" wrote in message

ups.com...



On 29 Jun, 11:09, "NickHK" wrote:
If that link does not apply, are you opening the WB in a browser ?

NickHK

"PhilM" wrote in message

oups.com... On 29 Jun,
10:12, "NickHK" wrote:
Never seen that one. Maybe this

?http://support.quickbooks.intuit.com...2/b1e9c8a.html

Otherwise, show your code.

NickHK

"PhilM" wrote in message

oups.com...

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?- Hide quoted text -

- Show quoted text -

Hi Nick

Its generating at this code

ThisWorkbook.Parent.DisplayAlerts = False
ThisWorkbook.Parent.ScreenUpdating = False- Hide quoted text -

- 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.- Hide quoted text -

- Show quoted text -

Cheers Nick,

Forcing it to open in Excel is the way!