Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel Command Bars and Remove Irritating Grey Bar
I have tried to use the following code to disable the commandbars in an Excel
tool I am developing. The code works fine, in disabling the command bars. However, I occasionally get an irritating grey bar, roughly about as thick as the 'DisplayFormulaBar', at the top of the page that obscures some of the text at the top of the spreadsheet. Does anyone know how to disable the commandbars and ensure that the grey bar is not produced at the top of the spreasheet page. Dim CBar As CommandBar Application.ActiveWindow.DisplayHeadings = False Application.DisplayFormulaBar = False For Each CBar In Application.CommandBars CBar.Enabled = False Next Yours in anticipation AB -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT HELP REQUIRED - EXCEL LOADS WITHOUT ANY COMMAND BARS AN | Excel Discussion (Misc queries) | |||
Can I disable the Save command for an Excel file? | Excel Discussion (Misc queries) | |||
how do Ii remove the grey page numbers in a work sheet | Excel Discussion (Misc queries) | |||
Hide all Excel tool/command bars except mine and reload on close | Excel Programming | |||
Minimize/Maximize excel restores command bars | Excel Programming |