| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating Toolbars,Sheet Tabs,Scroll Bars. etc.
Thank you.
Bob Phillips wrote: Option Explicit Private mFormulaBar Private mStatusbar Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = True Next oCB With ActiveWindow .DisplayHeadings = True .DisplayHorizontalScrollBar = True .DisplayVerticalScrollBar = True .DisplayWorkbookTabs = True End With Application.DisplayFormulaBar = mFormulaBar Application.StatusBar = mStatusBar End Sub Private Sub Workbook_Open() Dim oCB As CommandBar For Each oCB In Application.CommandBars oCB.Enabled = False Next oCB With ActiveWindow .DisplayHeadings = False .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = False .DisplayWorkbookTabs = False End With mFormulaBar = Application.DisplayFormulaBar Application.DisplayFormulaBar = False mStatusBar = Application.StatusBar Application.StatusBar = 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 I am having trouble writing a macro to disable all toolbars. I also want to turnoff the column and row headings as well as the sheet tabs and scroll bars. And I would like to restore all of these when the program closes. I only want the toolbars to be disabled during the program and I want the toolbars there if I open another Excel file. Is this possible to do with a macro? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200602/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show scroll bars and tabs in Excel 2007 | Setting up and Configuration of Excel | |||
| Lost scroll bars and sheet tabs??? | Excel Discussion (Misc queries) | |||
| Scroll bars without control tabs | Excel Worksheet Functions | |||
| Sheet tabs and scroll bars | Setting up and Configuration of Excel | |||
| Excel opens saved workbook without tabs or scroll bars showing? | Excel Worksheet Functions | |||
Threaded Mode
