Hi,

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

Tempy

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

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

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

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

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