Auto Execute Macro on Sheet

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I have a very simple macro (to run a filter on non-blank cells) which
I want to execute whenever a sheet is activated (ie the tab clicked
on).

The closest I have found is to save thr macro as Auto_Open, which will
do it on opening the workbook, but I need to keep re-filtering as I
move between sheets.

Is there an easy way to do this??

Thanks,

Pete
 
right click sheet tab>view code>left window select worksheet>right window
select activate
 
Back
Top