Mr AL,
If you right-click on the arrows to the left of the sheet tab names, you get
a sheet name list, effectively a listbox. Your users can select from there,
and if you give the sheets descriptive names all solved without code or
trickery.
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"MrAlMackay" wrote in message
...
Is it possible to use a List Box within a spreadsheet (this would be on
each
page) - that by selecting the first option in the list (e.g. Sheet 1, then
Sheet 2, etc.) it would navigate to each sheet?
Trying to put the finishing touches to a spreadsheet - navigating round
the
different sheets needs to be 'easier' for everyone - this way I can have a
descriptive title within the List box for each area.
As always your time, and expertise is greatly appreciated.
Many Thanks, Al. ( )