Hide & Show CommandBars/Ribbons in 2007

Hi All,

I am not sure I like Excel 2007 yet, I have been playing around with it all day and while it has some good features, it is hard to fathom in places. I expect it is just a matter of time to get used to it.

With previous versions of Excel, hiding and un-hiding commandbard and toolbars can be achieved in a number of ways, such as with the code below

ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
Dim cbar As CommandBar
For Each cbar In CommandBars
If cbar.Enabled And cbar.Type = msoBarTypeNormal Then
cbar.Visible = False
End If
Next cbar
CommandBars("Worksheet Menu Bar").Enabled = False

This does not work in Excel 2007, I have tried many methods but all seem to be redundant in 2007 - appreciate any help

Cheers,

GB

Re: Commandbars/toolbars 2007

Hi All Again,

The search function has lead me to another thread - Helmekki's of 2 weeks ago, please disregard my post - I will follow that threads lead. http://www.ozgrid.com/forum/showthread.php?t=70258

Cheers,

GB

Re: Hide & Show CommandBars/Ribbons in 2007

Thanks fellows,

The link I refer to is

http://www.ozgrid.com/forum/showthread.php?p=365699

I must admit, I have been trying to follow the thread and it has left me lost

Cheers,

GB

Re: Hide & Show CommandBars/Ribbons in 2007

Roy,

I agree with your frustration, however, given that most endusers like to play with programs to see what makes them tick (and I do this myself) means the programs can be corrupted if certain things are not 'protected'.

With Excel 2007, I will use this code (and for those that are interested, please note there a two routines, the 2nd is to return the displays to the original format)

Sub display()
Application.DisplayFullScreen = True
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
End Sub




Sub displaynot()
Application.DisplayFullScreen = False
ActiveWindow.DisplayHeadings = True
Application.DisplayFormulaBar = True
End Sub

This is very simple and does not secure the ribbon, all that is required is to double click on the title bar and it all reappears.

It is a start to my learning the new ways of Excel 2007, hopefully it wont hurt the brain too much...

Cheers,

G