Macro to hide Ribbons

[kelly mort]

Hell All,
I need a macro that will hide the ribbon tabs and show only the working area when i open my workbook. If this is possible then somebody should help me out. Thanks
Kelly

 

[Haluk]

Check the link below:

Hide or Display Ribbon Tab/Group/Control with getVisible

 

[Jaafar Tribak]

Or you can just use this Excel4Macro :

Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",False)"

Set the last argument to TRUE to show the ribbon back.

 

[Haluk]

According to your needs, this may hep you also;

Application.DisplayFullScreen = True

And, use "False" to switch back.

You can place these codes in your workbook's Open and Close events.

 

[kelly mort]

Or you can just use this Excel4Macro :

Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",False)"

Set the last argument to TRUE to show the ribbon back.

Yours did what i wanted then left the formula bar. Thanks for it. I can still use it.

 

[kelly mort]

According to your needs, this may hep you also;

Application.DisplayFullScreen = True

And, use "False" to switch back.

You can place these codes in your workbook's Open and Close events.

Yesss!!!!!!! This is the exact thing that i wanted. Thanks for it.

Ps.But when i click on restore, the ribbons show again on the window. How do i get rid of this?
Thanks again.
Kelly

 

[kelly mort]

Or you can just use this Excel4Macro :

Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"",False)"

Set the last argument to TRUE to show the ribbon back.

Oh okay. After unchecking formula bar from the view tab, your code worked like a charm!!!!!!
Thanks again.
Kelly

 

[CephasOz]

What about Application.SendKeys "^{F1}" - it operates as a toggle.