View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.morriss@wlucy.co.uk is offline
external usenet poster
 
Posts: 5
Default 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