Why is bottom bar indented

[kevs]

This is a minor thing , but annoying.

In Excel, when I open up worksheets, the bottom blue bar is always indented
a bit to the right, and I always have to drag it to the left to see the
first columns, anything I can do?

Kevs



OS 10.4.7
Office 2004

 

[JE McGimpsey]

This is a minor thing , but annoying.

In Excel, when I open up worksheets, the bottom blue bar is always indented
a bit to the right, and I always have to drag it to the left to see the
first columns, anything I can do?

Do you have a default workbook (i.e., a workbook named "Workbook", no
quotes, no extensions) in your startup folder? If so, then new
workbooks will open to wherever the active cell was when you saved that
file. Open it, select cell A1, and do a Save As, replacing the original.

 

[kevs]

Do you have a default workbook (i.e., a workbook named "Workbook", no
quotes, no extensions) in your startup folder? If so, then new
workbooks will open to wherever the active cell was when you saved that
file. Open it, select cell A1, and do a Save As, replacing the original.

Thanks JE!
Ok, I took a look, and both when launch Excel and when do new workbook, the
bottom blue bar is flush left, perfect no problem.

And MANY workbooks I open have no problem.

And for a test, I took scrolled to right, left the bar there, closed out,
reopened and the bar was perfect and fine on the left.

Still: here is the issue:
Ton's of times, I open workbooks and the bar is on the right in middle look:

http://img223.imageshack.us/img223/433/picture2vg0.png

and I start doing work, and realize I don't know where I am.

I would really like ALL workbooks to open with the bar flush on left.

Kevs


OS 10.4.7
Office 2004

 

[JE McGimpsey]

I would really like ALL workbooks to open with the bar flush on left.

Since workbooks open with the last scroll position before saving, that
would take putting a With Events class module in either your Personal
Macro Workbook or an add-in which intercepts the Workbook_Open event,
and creating an instance of the class when the PMW or add-in starts.

Of course, that won't be possible in XL2008 if you're looking to upgrade.

Post back if you want instructions.

 

[kevs]

Since workbooks open with the last scroll position before saving, that
would take putting a With Events class module in either your Personal
Macro Workbook or an add-in which intercepts the Workbook_Open event,
and creating an instance of the class when the PMW or add-in starts.

Of course, that won't be possible in XL2008 if you're looking to upgrade.

Post back if you want instructions.

JE, that was all Greek to me, should I just let this one go?
In other words, I can't easily tell Excel to have that scroll bar flush left
when I open all workbooks?

OS 10.4.7
Office 2004

 

[JE McGimpsey]

JE, that was all Greek to me, should I just let this one go?
In other words, I can't easily tell Excel to have that scroll bar flush left
when I open all workbooks?

Given that it was all greek, I'd recommend either letting it go, or hire
someone to create an add-in for you.

By default, XL will open a file with whatever sheet and cell were active
when the file was saved.

 

[kevs]

By default, XL will open a file with whatever sheet and cell were active
when the file was saved.

Thanks JE!

OS 10.4.7
Office 2004