| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activate pivot tables from a userform
How does one activate a pivot table refresh from a userform ?
I tried to use this code in the command button without success: ActiveSheet.PivotTables("StoichiometrySt1").Refres hTable I think the code doesnt work because the userform is activated in another sheet Also, is there a way to suppress the warning dialog asking if you want to replace the cells when you refresh the pivot table Can anyone help with either of these questions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| (Tom?) Pivot tables, code to refer to all pivot tables on template | Excel Programming | |||
| Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
| Userform.Activate | Excel Programming | |||
| Pivot tables-controlling user interaction with pivot tables | Excel Programming | |||
Linear Mode
