Hide or minimize Ribbon but show Quick Accsess Toolbar in VBA code

J

joelin

New Member
Joined
Oct 14, 2006
Messages
28
Hi all,

Is there a way using VBA to minimize the Ribbon in Excel 2007 and
disable maximize for a specific worksheet.

I find a way to hide the ribbon completely using eexecute excel4macro
but it hides even the munu.
I want to hide the ribbon but QAT is show on

thanks,


Sub HideRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

End Sub



Sub ShowRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"

End Sub
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Not ideal but it works

Code: 
Sub hide_unhide_Ribbons()
Application.SendKeys ("^{F1}")
End Sub
 
Upvote 0
Ctrl + F1 is the toogle switch to either hide or unhide
 
Upvote 0
Good afternoon,

I got here quite late, but maybe you can help me. The Ctrl+F1 combo toggles the ribbon on and off, but I only want to run it if it is visible, because otherwise it is already how I want it.

How can I tell (from code) if the ribbon is on or off?

Thank you.

DeepField
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
VBA Activate Code Emptying Clipboard
Replies
1
Views
262
Skyybot
Skyybot
P
  • Question Question
Trying to Hide the Min Max Close at top right
Replies
0
Views
418
Polino
P
P
  • Question Question
Hide everything other than the top MINIMIZE-EXPAND-CLOSE
Replies
2
Views
614
Jaafar Tribak
Jaafar Tribak
P
  • Question Question
Selected Cell Shown in Different Cell
Replies
2
Views
276
Pacman52
P
E
  • Solved
Quick VBA code to Hide Rows based on Cell Value
Replies
3
Views
597
Joe4
Joe4

Forum statistics

Threads
1,224,608
Messages
6,179,872
Members
452,949
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top