View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default linking worksheets

I have home-made XLA that should help: http://cjoint.com/?fwqZQdNgus
It is not protected: you can view & edit the code and the userform

To have tabs alpha ordered, right click on arrows left of tabs list, and
select "Sort tabs"

To select a sheet:
Right-click on a cell and select "Select sheet"
You can type the beginning of the name: it will select corresponding entry
of the list.
To validate: press Enter or double-click on a name
To cancel: press Escape

HTH
--
AP

"Graham7979" a écrit dans le message
de news: ...
I have an excel workbook with approx 30 worksheets, i want to create a menu
page wherby a cell (with the name of the worksheet in it) can be clicked
on
and this will take me direct to that work sheet, how do i do this ?