Thread: Drop down list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Drop down list

Hi
Did you know that you already have a dropdown list for your Tabs (Sheets).
At the bottom to the left of the sheet tabs, right click on the arrows and
you will get the listing of all your tabs.
HTH
John
"tofimoon3" wrote in message
...

Dear sir,

with best regards :
I have a workbook with around 25+ sheets on it and I was wondering if
its possible if I could put these sheets in a drop down list in say
cell A1( sheet 1) so it would be easier to navigate and jumping to the
sheets. Is this possible with or without VBA code if so how would I go
about doing it?

Thank you for your help and time in adavance...




--
tofimoon3