Assign Macro to tab

S

superkopite

Hey guys and gals,

Just a small prob, can't seem to find it in the help files either

Does anyone know how i can assign a macro to a worsheet tab, so that
everytime that worksheet is selected a macro is run

Cheers

James
 
L

L. Howard Kittle

Hi James,

Don't think you can assign to a tab, put your macro in this event macro of
the sheets and that should do it.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'ThisSheetMacro
End Sub

HTH
Regards,
Howard

"superkopite" <[email protected]>
wrote in message
news:[email protected]...
 
Top