View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Halim Halim is offline
external usenet poster
 
Posts: 182
Default 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 ?