Thread: Hide tool bar
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Hide tool bar

It is. Something like,

Application.Commandbars("Standard").Visible = False


or for the main menu, use

Application.Commandbars("Worksheet Menu Bar").Enabled = False

--

HTH

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


"Tempy" wrote in message
...
Hi,

Is it possible to hide the tool bar in excel using code ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***