Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-defined or object-defined error on closing
OK - the deafening silence tells me it was this week's stupid question - how
does the macro finish running if it's last line is "activeworkbook.close", thus closing the workbook that contains the macro..? Doh! I re-enabled the "Close" command from the "File" menu instead. I wear my "Dunce of the Week" hat in shame... :-) Pete "Peter Rooney" wrote: Good morning everyone. I have a workbook that customises the Excel Menubar. One of the commands allows the user to open another workbook, and to close the active workbook, the user selects a command from the customised menu that runs the macro "CloseMe" as shown below. ScreenReset is used to reset a number of screen customizations. The MsgBox shows me if "ScreenReset" has run OK (which it does), but when the workbook closes, the message "Application-defined or object-defined error on closing" is displayed. When I click OK on this message and the workbook (which is called from another workbook) closes, the Workbook_Activate macro in the calling workbook (which then becomes the active workbook) doesn't kick in. Sub CloseMe() On Error Resume Next 'Application.EnableEvents = False 'Application.DisplayAlerts = False Application.ScreenUpdating = False RequestPassword = False ScreenReset MsgBox ("Past ScreenReset") Application.ScreenUpdating = True ActiveWorkbook.Close End Sub Can anyone hazard a guess as to what's going on? Thanks in advance Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
Application-Defined or Object-Defined Error on simple code | Excel Programming | |||
Application-defined or object-defined error - missing the basics | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming |