Compile Error: Invalid outside procedure

I keep getting this error:
"Compile Error: Invalid outside procedure"

What I am doing is having a macro execute every time my Pivot table is refreshed, the macro invokes a format change.

Please Login or Register  to view this content.

What am I doing wrong? Please help.

Thanks in Advance.

Please use proper code tags in future.

You are placing commands out side of a routine, as the error states.

You probably want something more like this where each routine is called from the single event routine.

Please Login or Register  to view this content.

No worries, glad to help.