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
|