Assign Macro to tab
 

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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=509486

Assign Macro to tab
 

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"
wrote in message
...

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


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=509486