Thread: Macro Run
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
D@SE D@SE is offline
external usenet poster
 
Posts: 14
Default Macro Run

i think every time it comes back to my tab it is trying to run through the
whole process again and again.
--
David


"Mike H" wrote:

Hi,

Right click the sheet tab of the worksheet you want to call the macro and
paste this in. I've assumed you macro is in a general module. Change MySub to
the name of your sub

Private Sub Worksheet_Activate()
Call MySub
End Sub

Mike


"D@SE" wrote:

I am kind of green here. I have various macros in a workbook and i want one
particular macro to run each time a particular tab is clicked. i have read
other similar questions and responses and can not seem to follow. i guess i
need a little more detail. Thank you so much.
--
David