Bob,

I tried that code and it works perfectly. however it only works if the
worksheet it is looking for is not hidden. Do you know what the additional
code is to unhide and select the Sheet name in eg cell "H10".

"Bob Phillips" wrote:

Is the drop-down data validation? If so, it is just the cell the DV is in

Sheets(Range("H10").Value).Select

as an example

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ant" wrote in message
...
Probably a bit of an easy one...I have a selection of hidden worksheets
which
appear in a drop down box and linked to a cell with a vlookup. I than have
a
macro button which, once clicked, opens a worksheet. I want to add some
code
that opens up the result of the vlookup determined by the dropdown box.
For
example, if I select Sheet5 from the drop down box which in turn becomes
the
sheet name in the vlookup cell, when I click the Macro button, Sheet5
opens.
Currently I have Sheets("Sheet1").Select in the macro which obviously will
only open Sheet1. I have done this before but I can't remember the code.