You can use the recorder to find the code:

Application.CommandBars("[name]").Visible = True 'to make visible
Application.CommandBars("[name]").Visible = False 'to make invisible


"Sharon" wrote:

Hi

I have designed a custom toolbar that I want to display whenever a specific
workbook is opened and then turned off again when the workbook closes. Does
anyone know how to put that into the On Open event of the workbook? Thanks.
--
Sharon