Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the status bar to be displayed as default?
Currently everytime I open excel, I need to go to the Tools menu, click
Options, and then click the View tab and then select the Status bar check box |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the status bar to be displayed as default?
Hi
Copy the code below into your ThisWorkbook module of your file Private Sub Workbook_Open() Application.DisplayStatusBar = True End Sub To USe Copy code above Alt+F11 to enter the VB Editor In the right hand Explorer pane, navigate the the ThisWorkbook module of your Project and double click it Paste the Code into the right hand pane that appears Alt+F11 to return to Excel Save the workbook -- Regards Roger Govier "Aragorn" wrote in message ... Currently everytime I open excel, I need to go to the Tools menu, click Options, and then click the View tab and then select the Status bar check box __________ Information from ESET Smart Security, version of virus signature database 4538 (20091024) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4538 (20091024) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I make the status bar to be displayed as default?
Definitely not normal behaviour.
Does this happen with every workbook you open or just one? If one, you could have some code running in that workbook that turns Status Bar off. If all workbooks.........Do you have a Personal.xls opening that may do the deed? Do you have permission to save to the Registry which is where that setting is stored? Gord Dibben MS Excel MVP On Sat, 24 Oct 2009 08:06:01 -0700, Aragorn wrote: Currently everytime I open excel, I need to go to the Tools menu, click Options, and then click the View tab and then select the Status bar check box |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the status bar bigger? | Excel Worksheet Functions | |||
reuest formula for auto update status & status date | Excel Worksheet Functions | |||
Possible to make certain cells default to 0? | Excel Discussion (Misc queries) | |||
How do I make make comment format default? | Excel Discussion (Misc queries) | |||
"FIX" is displayed on status bar | Excel Worksheet Functions |