ChrisJ
10-22-2010, 01:19 AM
Hi,
I have a requirement to have a macro run when ever someone clicks/or changes worksheet on the next tab within a workbook (which has many tabs). This is going to be a prompt that reminds them to do certain things when they are in that worksheet.
I remember this sometime ago, but cannot remember what actually activates a macro on worksheet change..
Cheers
Chris
I have a requirement to have a macro run when ever someone clicks/or changes worksheet on the next tab within a workbook (which has many tabs). This is going to be a prompt that reminds them to do certain things when they are in that worksheet.
I remember this sometime ago, but cannot remember what actually activates a macro on worksheet change..
Cheers
Chris