Execute ribbons in specific workbook

[TheIntern]

Hello everyone,

as described in the title I want to use:

Sub Workbook_Open()

    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
Sub Workbook_BeforeClose(Cancel As Boolean)
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
    
End Sub

to hide the ribbons. My problem is that they are executed in all open excel files. Is it possible to limit this to the file with the macro, so the ribbons are still there in the other workbooks?

Thanks in advance,

The Intern

 

[GlennUK]

How about using the Workbook_Activate and Workbook_Deactivate events also, so that switching books triggers the hiding and restoring of the toolbar in the same way?

 

[TheIntern]

sorry for my late reply,
good Idea, thanks