Pivot tables and Macros

[Dust For Eyes]

I was looking to be able to manipulate (ie change selections from the
drop downs, not change the fields in the table or anything)and print
from a pivot table using a macro.

So how do I go about doing that?

When I set up a macro by recording the actions that I want to do, I
always get an error message when I try to run it as a macro.

 

[Debra Dalgleish]

What specific steps are you recording, and what error message do you get?
Can you click the Debug button, and see the line of code that is causing
the problem?

 

[Dust For Eyes]

Hmmm seems to be working now . . . I must have been doing something else
incorrectly.