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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
You must log in or register to reply here.

Similar threads

M
  • Solved
How to move custom VBA/ribbons
2
Replies
12
Views
482
missingsc
M
P
  • Question Question
Selected Cell Shown in Different Cell
Replies
2
Views
259
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
466
Amo840812
A
N
  • Question Question
Macro/VBA Create new folder and save workbook as
Replies
4
Views
467
NVRensburg
N
L
  • Question Question
Lost in Strings-When running macro another Excel workbook is opened
Replies
1
Views
237
Lacampeona
L

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

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