| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| Macro Help In Excel | Excel Discussion (Misc queries) | |||
| Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
