disabling custom menu upon closing workbook
 

How do I disable a custom menu upon closing an excel workbook, so that it is
not available in other excel workbooks ?

disabling custom menu upon closing workbook
 

Try this one
Sub DisableCmdBar()
dim cmb As CommandBarButton
For Each cmb In CommandBars("CIREPT_6").Controls
cmb.Enabled = false
Next ctl

End Sub
--
Regards,

Halim



"Woodsman" wrote:

How do I disable a custom menu upon closing an excel workbook, so that it is
not available in other excel workbooks ?