using automatic macros or object macros

hello,

i tried using the following code in a command button macro
*************************************
Sheets("Pivot of Data Collection").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Sheets("Download Pivot").Select
ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh

*************************************
and also in a worksheet, worksheet activate and then when i changed
worksheet or clicked the command button it threw an error at me when it tried
to run the macro, it doesn't seem to be able to use the code above

The code worked fine for me in a comandbutton click event. (only place
tested).

xl2002
--
Regards,
Tom Ogilvy


"Momo" <[email protected]> wrote in message
news:[email protected]...
> hello,
>
> i tried using the following code in a command button macro
> *************************************
> Sheets("Pivot of Data Collection").Select
> ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
> Sheets("Download Pivot").Select
> ActiveSheet.PivotTables("PivotTable3").PivotCache.Refresh
>
> *************************************
> and also in a worksheet, worksheet activate and then when i changed
> worksheet or clicked the command button it threw an error at me when it
tried
> to run the macro, it doesn't seem to be able to use the code above