View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Hiding menu options


Application.Commandbars(1).Controls("Format").Cont rols("Row").Visible =
False

as an example
--

HTH

Bob

"Alec Mclintock" wrote in message
...
Ca anyone help me with hiding menus and options in xl. I managed this in
a
very early version of xl but can't seem to be able to do it in the version
I
have at the moment - which itself is a bit long in the tooth (2002)