I have a spreadsheet with two sheets. I would like to run a macro to reapply a filter I have in Sheet 2. I would like the macro to run when I click on the Sheet 2 tab. Is this possible?
I have a spreadsheet with two sheets. I would like to run a macro to reapply a filter I have in Sheet 2. I would like the macro to run when I click on the Sheet 2 tab. Is this possible?
Last edited by barbercabinet58; 11-07-2012 at 02:13 PM. Reason: I solved my own problem
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
That's a good point. Here is the VB code that solved it.
![]()
Please Login or Register to view this content.
Last edited by arlu1201; 11-08-2012 at 03:19 PM. Reason: Use code tags.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks