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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You must log in or register to reply here.

Similar threads

M
  • Solved
How to move custom VBA/ribbons
2
Replies
12
Views
552
missingsc
M
P
  • Question Question
Selected Cell Shown in Different Cell
Replies
2
Views
262
Pacman52
P
A
  • Solved
Copy Entire Workbook, save as sheet name with current date, hide all sheets except one, & attach to email
Replies
2
Views
548
Amo840812
A
N
  • Question Question
Macro/VBA Create new folder and save workbook as
Replies
4
Views
508
NVRensburg
N
L
  • Question Question
Lost in Strings-When running macro another Excel workbook is opened
Replies
1
Views
242
Lacampeona
L

Forum statistics

Threads
1,223,894
Messages
6,175,254
Members
452,624
Latest member
gregg777

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