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