run a macro when i open a worksheet

[rcamr]

please can someone tell me how i can run a macro as soon as a worksheet is opened Not Workbook)

 

[Legacy 98055]

You can place the name of your macro in the worksheet's activate event.

<pre>
Private Sub Worksheet_Activate()
YourMacroNameHere
End Sub

</pre>

Tom

 

[rcamr]

sorry tom it doesnt seem to work
can you explain in further detail
Thanks

 

[Nimrod]

-1 rt click on sheet tab
-2 select view code
-3 see left vb project window in vb editor
-4 double click on sheet objects (i.e. sheet1)
-5 Paste code into each sheet object
-6 done

 

[Legacy 98055]

Paste your code...
When the sheet is activated, your code should run.
Tom