|
Unable to set the Display Alerts property of the application class
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? |
Unable to set the Display Alerts property of the application class
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? |
Unable to set the Display Alerts property of the application class
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 |
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 |
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. |
Unable to set the Display Alerts property of the application class
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. |
Unable to set the Display Alerts property of the application class
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! |
| All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com