#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default Status Bar

Status bar will not stay set on spreadsheets. I can get it so that a new
spreadsheet opent with status bar active as default. As soon as i open an old
spreadsheet the status bar defaults to the off setting for all future use,
including new workbooks. It can be set to on in options but it is only valid
for the session.
Any ideas?

Steve
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Status Bar

If you open excel in safe mode:

Close excel
Windows start button|Run
type:
Excel /safe

And then open your files

Does the statusbar disappear (after you've shown it)?

If it disappears, then I don't have a guess.

But if it doesn't disappear, then I bet you have a misbehaving macro--either in
one (or all??) of those old workbooks--or in a different workbook (like an addin
with code that monitors application events).

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Essentially, you'll turn off all the addins/startup workbooks and then open
excel. And then turn on each addin (closing and reopening) one at a time to
find the culprit.

Steve wrote:

Status bar will not stay set on spreadsheets. I can get it so that a new
spreadsheet opent with status bar active as default. As soon as i open an old
spreadsheet the status bar defaults to the off setting for all future use,
including new workbooks. It can be set to on in options but it is only valid
for the session.
Any ideas?

Steve


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Status... Steve HKG[_2_] Excel Discussion (Misc queries) 7 June 16th 08 07:01 PM
reuest formula for auto update status & status date PERANISH Excel Worksheet Functions 5 June 2nd 08 04:26 PM
Status Bar - Need to see # of # mfelker Excel Discussion (Misc queries) 1 April 23rd 07 09:15 PM
Status bar msg is gone Kent McPherson Setting up and Configuration of Excel 5 February 9th 07 09:32 PM
What is EN on status bar? gman100 Excel Discussion (Misc queries) 3 June 14th 05 11:40 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"