Thread: Unable to set the Display Alerts property of the application class
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
PhilM[_2_] PhilM[_2_] is offline
external usenet poster
  
Posts: 12
Default Unable to set the Display Alerts property of the application class
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.

Reply With QuoteReply With Quote