DAve
Excellent information thank you!
Is there a way to make the window taller that I get
when right clicking the VCR buttons?

Steve

"Dave Peterson" wrote:

Nope.

If you're looking to select a different worksheet...

If you rightclick on the VCR like controls (to the left of the worksheet tabs),
you'll see a list of worksheets in that workbook.

Other options:

Maybe you could use David McRitchie's Build Table of Contents to get the list
and the hyperlinks all at once:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet. There's a link on that site for an xl2007 version for the ribbon
(from Ron de Bruin).

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm


SteveZmyname wrote:

Hello
Is it possible to move the tab bar from the bottom
of the excel sheet to the right side?

I have over 20 tabs and think if they were listed vertically
they could all be seen on one screen.

thanks
Steve

--

Dave Peterson
.