There will be a easier way than this however this is one way

It can be doe not in one action but two

Set up you list ie Sheet 1, sheet 2, sheet3 etc

Us the dropdown list cell number in an If Formula which will be in the cell
above your drop down list

=IF(M16="SHEET 1",HYPERLINK("#'Road Cash Accounting'!AI2","Road cash
accounting PLEASE PRESS"), IF(M16="SHEET 2" etc,tec

In this case if sheet one is selected in your drop down list in M16,the
cell containing the above formula will appear as A HYPERLINK TO "road cash
accounting PLEASE PRESS"
THIS WOULD TAKE YOU TO ROAD CASH ACCOUNTING SHEET CELL AI2

IN excel 2003 you can have 7 if formulas , in 2007 I believe more

Hope this helps

Stewart





"Ruth" wrote:

Hi there

I have a form that opens automatically when the file is opened. I want to
add a drop down list to the form that has the names of the worksheets, and
when one is selected, it goes to the worksheet selected.

Is that possible, if so, how is it done?


--
Thank-you!
Ruth