VBA to hide toolbar / ribbon

M

melq64

New Member
Joined
Aug 21, 2017
Messages
49
When I open my workbook I would like the toolbar / ribbon to be completely hidden so that its in full screen by default. But I wan't it to be specific to my workbook only and not affect other excel files. Hope that makes sense.

I have tried the auto hide ribbon feature and couple of macros but they affect all workbooks.

Thanks in advance for any tips / suggestions:)
 

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.
You must log in or register to reply here.

Similar threads

M
  • Solved
How to move custom VBA/ribbons
2
Replies
12
Views
228
missingsc
M
P
  • Question
Selected Cell Shown in Different Cell
Replies
2
Views
205
Pacman52
P
N
  • Question
Macro/VBA Create new folder and save workbook as
Replies
4
Views
341
NVRensburg
N
L
  • Question
Lost in Strings-When running macro another Excel workbook is opened
Replies
1
Views
215
Lacampeona
L
J
  • Question
Closing (Hiding) multiple visible tabs.
Replies
1
Views
295
bobsan42
bobsan42

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,398
Latest member
rjsteward

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