Please help - run macro when switching sheets
Solved/Closed
Hello,
If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps running a macro upon clicking a new cell? I just don't want the workbook to move too slowly with every click running the macro.
Thank you!
If someone could tell me how to run a macro upon switching worksheets, that would be extremely helpful. If this is not possible, perhaps running a macro upon clicking a new cell? I just don't want the workbook to move too slowly with every click running the macro.
Thank you!
Related:
- Please help - run macro when switching sheets
- Sheets right to left - Guide
- Spell number in excel without macro - Guide
- Run macro when cell value changes by formula ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- Nokia keypad mobile not switching on ✓ - Nokia Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 7, 2010 at 10:51 AM
Jun 7, 2010 at 10:51 AM
You have to use either of the two routines in the sheet
This you would be using if you want macro to be fired as sheet is deactivated
Private Sub Worksheet_Deactivate()
End Sub
This you would be using if you want macro to be fired as sheet is activated
Private Sub Worksheet_Activate()
End Sub
This you would be using if you want macro to be fired as sheet is deactivated
Private Sub Worksheet_Deactivate()
End Sub
This you would be using if you want macro to be fired as sheet is activated
Private Sub Worksheet_Activate()
End Sub
Jun 7, 2010 at 03:33 PM