Formatting Pivot Chart via VB code

[sphynx]

I have an Access pivot chart that will be viewed by many different users, i need to be able to maintain the use of some of the pivot table filters but to lock out the ability to change the layout and formatting.

The easiest way I feel to achieve this would be to code the pivot chart to format in the way I require when opening, problem is i cant find any code anywhere!

Any help or ideas would be greatly appreciated