How Many Work Sheets

[MGumbrell]

Is there a way, and if there is would you please let me know of:-

If I highlight a number of worksheets in a workbook that the total number highlighted could be indicated in some way as it is proving very hard to manually count as when you scroll across keeping track of where you are is difficult.

Many Thanks, Matt

 

[shades]

Several options. Perhaps the easiest is to download ASAP Utilities. It is free, and it will build an Index page with every worksheet listed by name. Easy way to count worksheets that way. In addition you have a great add-in that will save you countless hours in other every-day tasks.
________
Yamaha Psr-500M

 

[MGumbrell]

Thank You Shades

That was a great link and I have installed it, as suggested there are a number of benificial macro's loaded which will save quite a fair few key strokes.

Matt

 

[MGumbrell]

Is it possible to improve this index function so that the sheet that is the index remains visible at all times whilst scrolling through the sheets?

I would assume that this would need to be done through code?

Thanks, Matt

 

[shades]

Tushar Mehta's Navigation add-in lists all worksheets and remains visible at all times that allows easy navigation.
________
PRONTO

 

[MGumbrell]

Thanks Shades

Another good Ad-In

Regards, Matt

 

[shades]

Also, if you right click on the sheet arrow at the bottom left, it lists all worksheets.
________
Og kush