Thread: Hiding Toolbar in Excel 2007

Hello ,

I have been to many posts so far in this forum but could not get the exact working code to hide all toolbars except my own. For convenience, attached is the excel file that I m currently working on.

Please let me know if you anything about hiding all toolbars in Excel 2007.

I found out this code :

Sub Auto_Open()
Dim cb As CommandBar
    For Each cb In CommandBars
        cb.Enabled = False
    Next cb
End Sub

and this one:

Private Sub Workbook_Open()

    ' Dimension a loop variable.
    Dim i As Integer
    ' Loop through the total number of toolbars.
    For i = 1 To Application.Toolbars.Count
        ' Hide each toolbar.
        Application.Toolbars(i).Visible = False
    ' End of loop.
    Next i

End Sub

Any sort of help will be appreciated. Best!

Sorry, in this post you can find out the attachment.

Can we lock the toolbars (all of them)? I don't want users to un-protect my sheet and edit.

Thanks romper. I appreciate it. Can you also enlighten me with this:
http://www.andypope.info/vba/ribboneditor.htm
What I know is that this is something with which you can customized your own toolbar. Anymore hints?

To edit the toolbars in 2007, you would need the use of XML and some form of XML editor. The last time I played around with them ribbons, I used these websites as references.

Part 1

Part 2

Part 3

Part 4

Epilogue.

Hope this helps.

Thanks Andy, That really helped me.