Thread: Hiding tools/options

Is there a way to hide the menu item tools/options from end users?

Run this in the workbook activate and in the deactivate set it to True

Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=522, Recursive:=True).Enabled = False

See also
http://www.rondebruin.nl/menuid.htm

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



"gfkbob" <gfkbob@discussions.microsoft.com> wrote in message news:378A594F-5922-409F-ADCE-10F8210A26F5@microsoft.com...
> Is there a way to hide the menu item tools/options from end users?