pmorris
11-02-2007, 03:57 AM
Hi All
I have been going through the forum for a while now and can't find what I need. :banghead:
Is it possible to run a macro when a user selects a worksheet? The worksheet I have contains a pivot table which I want to automatically update when the worksheet is selected. I have a macro that automatically updates the pivot but I have to select it to run it. What I want is for the macro to run automatically when the worksheet is selected.
Please could someone help!!!
Many Thanks
Paul
I have been going through the forum for a while now and can't find what I need. :banghead:
Is it possible to run a macro when a user selects a worksheet? The worksheet I have contains a pivot table which I want to automatically update when the worksheet is selected. I have a macro that automatically updates the pivot but I have to select it to run it. What I want is for the macro to run automatically when the worksheet is selected.
Please could someone help!!!
Many Thanks
Paul