[Excel 2003]

I have a question regarding the activation of pivot table refreshes from a
userform.

I tried to use the following code in a command button without success:

ActiveSheet.PivotTables("PovotTableName").RefreshT able

I think the code doesnt work because the userform is in another
sheet to the pivot table, however I need this to be the case since I have 10
different sheets, each with a different pivot table.

Can anyone help ?