running a macro from a list
 

Hi I'm new here.. hopefully somebody can help me with this qeuery...!

I have a list in a worksheet (using 'validation' from the 'data' menu).
I want to run a macro depending on what option is selected from the
list

i.e. if you select 'sheet 1' then the macro called 'macro1' will run...
if you select 'sheet 2' then the macro called 'macro2' will run...etc

is this possible?

many thanks

rufusf


--
rufusf