View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Unable to set the Display Alerts property of the application class

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