Thread: Drop down list
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Drop down list

Hi,

You can try this.

Ctrl+k
in Link to (LHS) This document|and select the sheet in the current
workbook|Ok the link will get pasted in the cell you had selected.
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"tofimoon3" wrote:


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