Run Macro when entering a worksheet

[Papi]

Is it possible to have a macro run each time entering a worksheet within an open workbook?

 

[JLGWhiz]

Is it possible to have a macro run each time entering a worksheet within an open workbook?

If you mean when you activate a worksheet, you would use the Worksheet_Activate event to run the code. If you mean when data is entered into a worksheet then either the Worksheet_Change event or the Worksheet_SelectionChange events could be used. These would be Private Sub stored in the worksheet code module.