run macro when worksheet is selected

[Carl]

I want to find out if it is possible to have a marco run
whenever a worksheet is selected. I have one worksheet
that contains parameters the user can change and another
worksheet that contains the data. I want a macro to
reselect the filter whenever the spreadsheet containing
the data is selected so the paramaters the user selected
will be reflected in the filtered list. I have already
created the filter, I just want a macro to reselect it so
the data reflects the selected parameters. Another
option would be to run the macro when I exit the
parameter worksheet if that is a possibility.

 

[Ron de Bruin]

Hi Carl

You can use this events


Private Sub Worksheet_Activate()

End Sub

Private Sub Worksheet_Deactivate()

End Sub

 

[Guest]

Thanks Ron. Do I need to place the Worksheet_Deactivate
event in any particular code module? Perhaps the
worksheet code module?

-----Original Message-----
Hi Carl

You can use this events


Private Sub Worksheet_Activate()

End Sub

Private Sub Worksheet_Deactivate()

End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Carl" <[email protected]> wrote in

message news:[email protected]...

 

[Ron de Bruin]

Place the code in a Sheet module

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel

 

[Guest]

Thanks Ron. I'll give that a try.

-----Original Message-----
Place the code in a Sheet module

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel


--
Regards Ron de Bruin
http://www.rondebruin.nl





.