Need help starting a macro

  • Thread starter Thread starter moorso
  • Start date Start date
M

moorso

I have a macro I would like to run when a partiuclar sheet is selected
in a workbook but cant find where that is covered. I would also like
that same macro to run when the sheet is closed and another sheet is
opened. Is there such a command in Excel. TIA
 
You need an event.

Lookup "SheetActivate Event" in Excel's VBA Help file. Specifically, you
require Worksheet_Activate and Worksheet_Deactivate.
 
See response in .programming.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top