select worksheet and run macro

Hi,

I am trying to run some code when a worksheet is selected.

I'm doing this using a macro currently (code below), but this requires that i use a quick menu button and i would like to make it a form button and assign a macro to it (so i can distribute the file without everyone having to create a menu button).

I would like to replace (or modify) the code below to select any sheet other than the ones named "a" and "b".

Can someone help modify this code please ?

Many thanks,

Please Login or Register  to view this content.

that's right, i'm looking to change this code to be able to do that, sorry, i didn't explain very well.

i'm pretty sure i can use worksheets(1).select, but not sure how to mod the code above to replace.

Thanks.

anyone please help ?