VBA to hide Formula Bar, Status Bar and Ribbon on specific worksheet (Dashboard)

**WIFG** · 09-09-2022, 07:12 PM

I have a spread sheet which is a functional dashboard with slicers to change the reports. I would like to hide the ribbon, formula bar and status bar for this sheet. It is a protected sheet which allows only the slicers be changed. I have searched for a solution but keep finding ways to hide these elements across the workbook, not for a specific sheet.

**pjwhitfield** · 09-12-2022, 01:54 PM

You could use the methods you've found to hide/show the items but put the code in the Worksheet_Activate event and then make them reappear in the Worksheet_Deactivate event

VBA to hide Formula Bar, Status Bar and Ribbon on specific worksheet (Dashboard)

LinkBack

Thread Tools

Rate This Thread

Display

VBA to hide Formula Bar, Status Bar and Ribbon on specific worksheet (Dashboard)

Re: VBA to hide Formula Bar, Status Bar and Ribbon on specific worksheet (Dashboard)

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to hide ribbon, formula bar and worsheets in only selected workbook

[SOLVED] Hide ribbon/formula bar for this workbook only

Hide ribbon and formula bar for all workbooks opened in Excel

Hide Ribbon, Formula Bar, Gridlines, Heading

hide ribbon and formula bar on 1 workbook

Hide specific ribbon control/tab

[SOLVED] Disable ribbon element if workbook doesnt contain a specific worksheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions