Validation/Macros
 

You can also right click on the Arrows next to the Sheet Tabs to
get a list of all your sheets

--
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...