Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_BeforeClose
I have some 'DeleteMenus' macros in the 'Workbook_BeforeClose'
procedure which works fine. Private Sub Workbook_BeforeClose(Cancel As Boolean) Run "DeleteModelsOptions" Run "DeleteCostMenu" Run "DeleteSpecListMenu" ActiveWorkbook.Close savechanges:=False End Sub The problem I have is if a new workbook is opened as well and then closed, it seems to run the 'DeleteMenus' macros of the other workbook, therefore removing the menu's. Don't understand why this is happening as the 'new' workbook_beforeclose procedure is empty. Help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_BeforeClose
Hi paul,
maybe this is your problem: ActiveWorkbook.Close savechanges:=False THISworkbook.close arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_BeforeClose | Excel Discussion (Misc queries) | |||
workbook_beforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming | |||
Workbook_BeforeClose | Excel Programming |