Protecting Pivot Tables

[Sir Yendor]

I am very new to pivot tables but have created a pretty decent document that does everythign I need. I now have to share this document with others who could very easily screw things up accidentaly.

Without Pivot tables, I'd simply protect the cells I didn't want them to have the ability to change. If I do that, I get a "debug" error when I change sheets within the document.

Is there a way around this? If so, what is it?

Thanks

[VBA Noob]

Hi,

This link should help

http://www.contextures.com/xlPivot12.html

VBA Noob

[Sir Yendor]

Thanks for the quick reply. I'll give this a shot.

[VBA Noob]

No problem

Hope it solves your problem

VBA Noob