Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Open Excel with Just Menu Bar in Full Screen
I have a spreadsheet which will be completed by various users. I want the
spreadsheet to open up to a specific sheet (already got that) and only show the Menu Bar. I want the user to be able to open another spreadsheet, not this one and have their toolbars as they always do. Is this possible? Appreciate the advice! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Open Excel with Just Menu Bar in Full Screen
Option Explicit
Private mFormulaBar Private Sub Workbook_Activate() ManageCBs False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) ManageCBs True End Sub Private Sub Workbook_Deactivate() ManageCBs True End Sub Private Sub Workbook_Open() ManageCBs False End Sub Private Sub ManageCBs(Show As Boolean) Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = Show Next oCB If Show Then Application.DisplayFormulaBar = mFormulaBar Else mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False Application.CommandBars("Worksheet Menu Bar").Enabled = True End If End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Goldenfoot" wrote in message ... I have a spreadsheet which will be completed by various users. I want the spreadsheet to open up to a specific sheet (already got that) and only show the Menu Bar. I want the user to be able to open another spreadsheet, not this one and have their toolbars as they always do. Is this possible? Appreciate the advice! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007: Suggestion on for a full screen page reference menu | Excel Worksheet Functions | |||
Full screen toolbar | Excel Discussion (Misc queries) | |||
sometimes cannot see existing worksheet when i open it without full screen toggled on | Excel Discussion (Misc queries) | |||
Size of excel work book is not full screen | Excel Discussion (Misc queries) | |||
i can not get full screen to remain off | Excel Discussion (Misc queries) |