| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Executing a command when clicking on a tab
I need to write a macro that will automatically start whenever a user clicks
on (i.e., switches to) a certain tab (Sheet2). And all the macro needs to do execute the PivotTable "Refresh Data" command. Can someone kindly tell me how to do this? Thanks in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Store data JUST entered in Activecell after clicking command button on worksheet | Excel Programming | |||
| executing an add in | Excel Programming | |||
| can I set up a sort command to happen by clicking on a table headi | Excel Programming | |||
| Error when executing 'Charts.Add' command | Excel Programming | |||
| Keyboard command to replace double clicking the fill handle | Excel Discussion (Misc queries) | |||
Threaded Mode
