Trigger Macro with Worksheet Tab selection

[torweb]

I have a macro I'd like to run when a worksheet tab is selected. The macro updates content in various cells. That action is now triggered with a command button (linked to macro), but I'd like it to take place when the user selects that worksheet tab....

Thank you for any help...pointers..!!

 

[cornflakegirl]

Go back to Excel Questions and click the New Thread button in the top left.

 

[passinthru]

Suhas, go to

http://www.mrexcel.com/forum/forumdisplay.php?f=10

And look near the top left of the page for a "New Thread" button. It's just above the blue line, below the MrExcel.com logo.