Assign Macro to tab

  • Thread starter Thread starter superkopite
  • Start date Start date
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
 
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]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign a macro to the save button 4
Assign different macros for True/False button 2
not able to assign macro 4
Assigning Macros in Excel 2007 1
Excel 2003 - assign macro to custom toolbar button 1
macro does not assign to menu? 2
assigning macro 17
Macros - Tickmarks 0

Back
Top