Show/Hide toolbars for current workbook only mankit87 Oct 12th 2011 Re: Show/Hide toolbars for current workbook onlyHi,change visible to enable.wb.Application.CommandBars("Worksheet Menu Bar").Enabled = False