lessthanme5
Registered User.
- Local time
- Today, 05:43
- Joined
- Mar 7, 2006
- Messages
- 43
Hi,
Im trying to work on a spreadsheet and want to creat a list of sheet names for a drop down box. but........ the value of the box must select the relevent sheet.
ive tried to play around with it for ages, but i just cant get it to work.
ive never seen it done but it must be possible?!?!?!
I tried the "Sheets((TEXTREF(A1,TRUE))).select"
which i thought would use cell A1 and try to open a location using its value.
can anybody do this?
THanks
Im trying to work on a spreadsheet and want to creat a list of sheet names for a drop down box. but........ the value of the box must select the relevent sheet.
ive tried to play around with it for ages, but i just cant get it to work.
ive never seen it done but it must be possible?!?!?!
I tried the "Sheets((TEXTREF(A1,TRUE))).select"
which i thought would use cell A1 and try to open a location using its value.
can anybody do this?
THanks
