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?

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

Otherwise, show your code.

NickHK

"PhilM" wrote in message
ups.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?

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

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

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

NickHK

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

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

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

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

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" 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

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