Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel2007VBA ... Hide Ribbon Bar(VBA Code)

  Asked By: Kerri    Date: Aug 13    Category: MS Office    Views: 3091
  

I am trying to be able to ONLY display my customized Toolbar in Excel 2007
which shows perfectly in Excel 2003, however when when I do the following
VBA code to not display the Excel 2007 Ribbon, my customized Toolbar
as it was shown in Excel 2003 is not displayed. How can I displayed my
customized Toolbar; it not taking up so much space in Excel 2007 near
the top of the Excel 2007 screen much like it did with Excel 2003 ?
=====
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Excel2007VBA ... Hide Ribbon Bar(VBA Code) Or get search suggestion and latest updates.




Tagged: