You obviously have a code that reactivates the menus and command bars when you close the workbook.
It may be a good idea to place that code in the workbook module such as
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
'you code to reinstall menus and toolbars
End Sub
Then of course the code to remove the menus and tool bars will have to be run when you activate the workbook again.
Private Sub Workbook_WindowActivate(ByVal Wn As Window)
'code to remove toolbars and menus
End Sub
If it is a named VBA code in a regular module, you would just have to call the code for each action.
Bookmarks