Thread: Run Macro when click on different tab in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan McQuaid via OfficeKB.com Alan McQuaid via OfficeKB.com is offline
external usenet poster
  
Posts: 25
Default Run Macro when click on different tab in Excel
Supe,

You can use the Worksheet_Activate event. Take a look at the Worksheet Object
Event section in the Help on VBA

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200907/1

Reply With QuoteReply With Quote