Hide tool bar
 

Hi,

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

Tempy

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

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 ***

Hide tool bar
 

Hi Bob,

Thanks works like a dream.... i'm takinc a long shot here is there code
that would cover multiple toolbars or must one do them all individually
?

Tempy

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

Hide tool bar
 

Anybody Heeeeeeelp,
I have just hidden all my tool bars and there is an error in my code
!!!!

Could somebody tell me how to get into the document without my Auto code
running?
I have tried holding in the shift key while opening and it doesnt seem
to work ?

Tempy

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

Hide tool bar
 

Just open the workbook with Macros disabled.

You can also reset the commandbars from within the VBE Immediate window by
typing the command, such as

Application.Commandbars("Standard").Visible = True
and hit return

--

HTH

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


"Tempy" wrote in message
...
Anybody Heeeeeeelp,
I have just hidden all my tool bars and there is an error in my code
!!!!

Could somebody tell me how to get into the document without my Auto code
running?
I have tried holding in the shift key while opening and it doesnt seem
to work ?

Tempy

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