activate pivot tables from a userform

Roger on Excel

Guest

Posts: n/a

27th Nov 2009

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").RefreshTable

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?

« UserForm show question | get complex data from other xls file »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Tables - refresh from Userform command button	Roger on Excel	Microsoft Excel Programming	2	27th Nov 2009 09:02 PM
Building pivot tables in Excel 2007 based on existing pivot tables?	jj.jigga.johns@gmail.com	Microsoft Excel Misc	4	26th Dec 2007 08:05 PM
(Tom?) Pivot tables, code to refer to all pivot tables on template	=?Utf-8?B?a2x5c2VsbA==?=	Microsoft Excel Programming	0	20th Jul 2007 09:32 PM
Activating userform and filling it with data form row where userform is activate	Marthijn Beusekom via OfficeKB.com	Microsoft Excel Programming	3	6th May 2005 05:44 PM
Pivot Chart/Tables & Userform	hce	Microsoft Excel Misc	0	11th Sep 2004 04:37 PM