Hi Jock

Sub test()
On Error Resume Next
Sheets(ActiveSheet.Range("A1").Value).Select
On Error GoTo 0
End Sub

With the data validation list in A1 try this

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Jock" wrote in message ...
Hi...

Eek someone help me!

I have 12 sheets one for each month and on each a validation drop down menu with the list ofm months. Has anyone got any code
to help me so that when I the cell is activayed by the validation value the sheet can change to the correct month...

A beer in the mail to anyone who can help me out...I know its easy...but not for a novice like me...

Jock...

Oops, I forgot to tell you that you must run this macro in the Change event.

See Tom's reply

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Ron de Bruin" wrote in message ...
Hi Jock

Sub test()
On Error Resume Next
Sheets(ActiveSheet.Range("A1").Value).Select
On Error GoTo 0
End Sub

With the data validation list in A1 try this

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Jock" wrote in message ...
Hi...

Eek someone help me!

I have 12 sheets one for each month and on each a validation drop down menu with the list ofm months. Has anyone got any
code
to help me so that when I the cell is activayed by the validation value the sheet can change to the correct month...

A beer in the mail to anyone who can help me out...I know its easy...but not for a novice like me...

Jock...