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

Workbook_BeforeClose
 

Hi paul,

maybe this is your problem:
ActiveWorkbook.Close savechanges:=False

THISworkbook.close

arno