Pivot Chart Lock Down

[SpentGeezer]

Greetings,

I have a Pivot chart form that I have embedded in another form. I want the user to be able to use the pivot chart, but not be able to right click it and add fields etc..

Any tips on how to achieve this?

Spent.

 

[md2017]

I would also very much like to be able to do this.

Thanks

Nick

 

[SpentGeezer]

I ended up putting it in an MDE and creating a seperate form where the user could select the columns and other attributes for the pivot. Then used VBA to alter the Pivot. This was a lot of work, but does the job.