| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run Macro when changing tabs
I have a pivot table set up that runs off data from a different tabe in the
same workbook. The data will be refreshed monthly and some formatting needs to be done to the data before refreshing the pivot table. I have set up a macro that will do the formatting. Is there a way where the macro would run as soon as you click on the tab for the pivot table? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Excell Sheet Tabs to Different Colors | Excel Discussion (Misc queries) | |||
| Changing the size of sheetname tabs | Excel Discussion (Misc queries) | |||
| Changing the appearance of the cursor/pointer & size of tabs | Excel Discussion (Misc queries) | |||
| Changing Tabs to Specific Cells | Excel Discussion (Misc queries) | |||
| Changing colors of tabs | Excel Discussion (Misc queries) | |||
Threaded Mode
