disabling custom menu upon closing workbook

's Computer Specifications

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

's Computer Specifications

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 ?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Menu For Each Sheet In A Workbook	Steve	Microsoft Excel Programming	2	25th Aug 2007 03:14 AM
Disabling menu options in a Custom Menu	=?Utf-8?B?VkJBZ3JvdXBpZQ==?=	Microsoft Access	4	9th Mar 2006 08:00 PM
removing custom toolbars when closing workbook	Tony	Microsoft Excel Programming	4	10th Aug 2004 12:01 PM
Custom Menu return to Excel Menu upon Closing	VetcalcReport	Microsoft Excel Programming	2	2nd Aug 2004 02:59 PM
How do i attach a custom menu to a workbook???	Carmelo	Microsoft Excel Misc	1	8th Apr 2004 05:30 AM