Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Formula Bar / Toolbars etc
Can anybosy please tell me how to remove all the users toolbars and formulae bars when the workbook is opened and then put them all back when the workbook is closed? Many Thank Benn -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=502829 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Formula Bar / Toolbars etc
Option Explicit
Private mFormulaBar Private Sub Workbook_Open() Dim oCB As CommandBar 'Remove commandbars For Each oCB In Application.CommandBars oCB.Enabled = False Next 'RemoveFormulaBar mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim oCB As CommandBar 'Restore commandbars For Each oCB In Application.CommandBars oCB.Enabled = True Next 'RestoreFormulaBar Application.DisplayFormulaBar = mFormulaBar 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 Phillips (remove nothere from email address if mailing direct) "cassy01" wrote in message ... Can anybosy please tell me how to remove all the users toolbars and formulae bars when the workbook is opened and then put them all back when the workbook is closed? Many Thank Benn -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=502829 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove Formula Bar / Toolbars etc
Can anybody please tell me how to remove all the users toolbars and
formulae bars Just throwing this out as a possible alternative... Sub FullScreenToggle() With Application .DisplayFullScreen = Not (.DisplayFullScreen) End With End Sub Perhaps in the Workbook_Open / Workbook_BeforeClose event. -- Dana DeLouis Win XP & Office 2003 "cassy01" wrote in message ... Can anybosy please tell me how to remove all the users toolbars and formulae bars when the workbook is opened and then put them all back when the workbook is closed? Many Thank Benn -- cassy01 ------------------------------------------------------------------------ cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780 View this thread: http://www.excelforum.com/showthread...hreadid=502829 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
remove " $ " from formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How can I remove a formula from a cell and still have the value? | Excel Worksheet Functions |