Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and hide ALL menu in Excel 2007?
Hi guys,
I need your help !! Any idea how to disable in VBA all menus in EXCEL 2007? On the top of that I need to hide also the main title on the top with Excel + name of the file appear - so it doesn't look Excel any more Many thanks for your precious help! Yvan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and hide ALL menu in Excel 2007?
Option Explicit
Private mFormulaBar Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = True Next oCB Application.DisplayFormulaBar = mFormulaBar End Sub Private Sub Workbook_Open() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False 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) "Marcus" wrote in message ... Hi guys, I need your help !! Any idea how to disable in VBA all menus in EXCEL 2007? On the top of that I need to hide also the main title on the top with Excel + name of the file appear - so it doesn't look Excel any more Many thanks for your precious help! Yvan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable and hide ALL menu in Excel 2007?
GREAT!!!! THANK YOU Phillips
BTW, do you know how we can remove the Excel green flag (top left), NAME of the file (top middle) and the red cross (top right)? Many thanks for you help!!!! Yvan "Bob Phillips" wrote: Option Explicit Private mFormulaBar Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = True Next oCB Application.DisplayFormulaBar = mFormulaBar End Sub Private Sub Workbook_Open() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False 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) "Marcus" wrote in message ... Hi guys, I need your help !! Any idea how to disable in VBA all menus in EXCEL 2007? On the top of that I need to hide also the main title on the top with Excel + name of the file appear - so it doesn't look Excel any more Many thanks for your precious help! Yvan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 format menu disable | Setting up and Configuration of Excel | |||
Hide ribbon or menu bar in Excel 2007 | Excel Programming | |||
Context Menu (Sub-Menu Disable/Enable) | Excel Programming | |||
How disable menu command on excel view | Excel Discussion (Misc queries) | |||
Menu Items and Disable/Enable in Excel 2003 | Excel Programming |