What sheet am I on?

[mike001100]

Hi all,

a very simple question: I'm using office 2003 and I cannot see what sheet I am on (e.g. sheet 23/160)... where can I find this info?

Thanks.

[NBVC]

Do you not see the tabs at the bottom of the excel screen?

Not sure what you mean?

[mike001100]

Do you not see the tabs at the bottom of the excel screen?

Not sure what you mean?

Yes, I see those, but they are renamed.

I would like to know if I am like on sheet 1/160 or 2/160 or 120/160, etc... (I'm interested in the first number of those two at least).

[ChemistB]

What are they renamed to? and where were they named 1/160, etc? A Previous version of Excel? So there are 160 sheets in your workbook? Is your question "How do I know how many sheets are in my workbook and what relative number sheet am I on?"

[mike001100]

They are renamed to codes that correspond to other things... like 1221009, 0099233, etc.

I know there are approx. 160 sheets because I made the workbook in Open office, which says "sheet 1/160" etc.

[shg]

Please Login or Register  to view this content.

[mike001100]

Please Login or Register  to view this content.

I don't need it as a script/code... I want to click somewhere and Excel should say "Sheet 1/160" for example... similarly to when you do Tools->Word Count in MS Word.

[shg]

But since Excel doesn't have that functionality, your options are ...?

Google excel worksheet index -- perhaps you'll find something you can adapt.

[ChemistB]

Using what shg provided, one suggestion would be to create the following macro

Please Login or Register  to view this content.

A messagebox will pop up telling you what #/Total #.

Customize your toolbar to have an icon activating this macro and whenever you want to know what sheet# you are on, click on the icon. Would that work for you?

[mike001100]

Thank you guys,

sorry shg, I assumed there was some integrated method in Excel and I just didn't know of it...

Thanks once again.