View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Jackie Jackie is offline
external usenet poster
 
Posts: 78
Default Selecting a specific worksheet

Hi John,

This discussion group has answered so many questions for me. Thank you! I
had no idea that shortcut existed. I will try this and see if I can learn
more about a Sheet Navigation Toolbard that Gord recommended.

Many, many thanks from this 'newbie' Excel user ~

Jackie

"John" wrote:

Hi Jackie
Maybe not what you want but did you know if you right click to the left of your
first tab, the scroll left-right arrows, you will get a drop-down menu with all
your Tabs and last entry showing "More sheets".
HTH
John
"Jackie" wrote in message
...
I have 40 tabs (worksheets) named in my workbook. Is there an easier way to
go to a specific worksheet without have to tab over and past all the other
worksheets?

I just learned you can automatically alphabetize named tabs using VBA, but I
don't know anything about VBA.

Thank you,
Jackie