ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I project an Excel spreadsheet without the menu bar? (https://www.excelbanter.com/excel-discussion-misc-queries/57635-can-i-project-excel-spreadsheet-without-menu-bar.html)

DEN-RIK

Can I project an Excel spreadsheet without the menu bar?
 
Is there any way to "auto-hide" the worksheet menu bar in Excel the way we
can "auto-hide" the taskbar? I want to project an Excel spreadsheet onto a
screen but do not want the worksheet menu bar to be visible.
Thank you to anyone who can help.

Chip Pearson

Can I project an Excel spreadsheet without the menu bar?
 
Go to the View menu, choose Toolbars, scroll down to Worksheet
Menu Bar, and uncheck it. Or, with VBA,

Application.CommandBars("Worksheet Menu Bar").Enabled = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"DEN-RIK" wrote in message
...
Is there any way to "auto-hide" the worksheet menu bar in Excel
the way we
can "auto-hide" the taskbar? I want to project an Excel
spreadsheet onto a
screen but do not want the worksheet menu bar to be visible.
Thank you to anyone who can help.





All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com