G Guest Aug 15, 2007 #1 How do I disable a custom menu upon closing an excel workbook, so that it is not available in other excel workbooks ?
How do I disable a custom menu upon closing an excel workbook, so that it is not available in other excel workbooks ?
G Guest Aug 15, 2007 #2 Try this one Sub DisableCmdBar() dim cmb As CommandBarButton For Each cmb In CommandBars("CIREPT_6").Controls cmb.Enabled = false Next ctl End Sub
Try this one Sub DisableCmdBar() dim cmb As CommandBarButton For Each cmb In CommandBars("CIREPT_6").Controls cmb.Enabled = false Next ctl End Sub