Hi,
Addition of the following Macros in the ThisWorkbook Code Module may help you:
Lewis![]()
Private Sub Workbook_Activate() Application.ExecuteExcel4Macro "show.toolbar(""ribbon"",false)" End Sub Private Sub Workbook_Deactivate() Application.ExecuteExcel4Macro "show.toolbar(""ribbon"",true)" End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ExecuteExcel4Macro "show.toolbar(""ribbon"",true)" End Sub
Bookmarks