| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display alerts error
No, the code is not in a sheet module.
"Tom Ogilvy" wrote: Nothing in the code that shouldn't work in Excel 2002. I assume the code isn't in the sheet module for Sheet3. -- Regards, Tom Ogilvy "AWSD" wrote in message ... Yes, it is executed within Excel and written in VBA. It is executed when the user clicks a button. "Tom Ogilvy" wrote: That is a peculiar error. Is this code being executed within Excel and written in VBA? -- Regards, Tom Ogilvy "AWSD" wrote in message ... Hi, Within a Sub I have the following code fragment: Application.ScreenUpdating = False Application.DisplayAlerts = False If SheetExists("Sheet3") Then Sheets("Sheet3").Delete Application.DisplayAlerts = True This works fine in Excel 2000 but a user using Excel 2002 has reported the following error: Method "display Alerts" of object '_Application' failed. I cant see why the error is being raised. Is there a problem in 2002? Is there a solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Alerts | Excel Discussion (Misc queries) | |||
| Stopping Display Alerts | Excel Programming | |||
| Display Alerts | Excel Programming | |||
| Display Alerts | Excel Programming | |||
| Code to not display delete sheet alerts | Excel Programming | |||
Threaded Mode
