I have a workbook with many worksheets in it.
I would like to make a macro run automatically whenever I click on particular worksheet (one of the many).
The purpose is this:
I change something within some other worksheets, and then whenever I click this particular worksheet I want a macro to make a reset to something.
So It's simply a matter of making the macro run as soon as this worksheet is clicked.
Does anybody know how it can be done?
Put the macro in the worksheet_activate procedure:
When you're done it should look like:
- Right click the desired sheet tab, select View Code
- In the Code Pane, select "worksheet" from the OBJECT listbox
- In the adjacent PROCEDURE listbox, select WORKSHEET_ACTIVATE
- Paste your macro here
Private Sub Worksheet_Activate()
.End Sub
My macro code
.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks