Disable Items in Menubar

[cassy01]

Hi is it possible to disble some of the menus in the menubar ???

i have created a menubar of my own for a specific workbook so when it opens it enables my custom menubar but still shows the default one.

any way of getting rid of the default menu then putting it back when it closes ??

thaks

[Ron de Bruin]

See
http://www.rondebruin.com/menuid.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"cassy01" <[email protected]> wrote in message
news:[email protected]...
>
> Hi is it possible to disble some of the menus in the menubar ???
>
> i have created a menubar of my own for a specific workbook so when it
> opens it enables my custom menubar but still shows the default one.
>
> any way of getting rid of the default menu then putting it back when it
> closes ??
>
> thaks
>
>
> --
> cassy01
> ------------------------------------------------------------------------
> cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780
> View this thread: http://www.excelforum.com/showthread...hreadid=483253
>

[Bob Phillips]

Application.Commandbars(1).Controls("Tools").Enabled = False

and set to True after

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cassy01" <[email protected]> wrote in
message news:[email protected]...
>
> Hi is it possible to disble some of the menus in the menubar ???
>
> i have created a menubar of my own for a specific workbook so when it
> opens it enables my custom menubar but still shows the default one.
>
> any way of getting rid of the default menu then putting it back when it
> closes ??
>
> thaks
>
>
> --
> cassy01
> ------------------------------------------------------------------------
> cassy01's Profile:
http://www.excelforum.com/member.php...nfo&userid=780
> View this thread: http://www.excelforum.com/showthread...hreadid=483253
>