Locking/Formatting a Pivot chart

access , db United Kingdom
  • 13 years ago

    I am fairly new to access so please bear with me. I have been putting together a waste database at work, data is entered online within manufacturing and analysed in various ways via queries, graphs and reports

     I have a pivot chart which plots target waste vs actual waste over time dependent on a specific product being selected. the problem i have is that i need to be able to allow the product filter to be changed but need to lock down the rest of the sheet so that it doesnt get changed, lots of people will be using & it will get altered within about 2 hours of going live!

    I have tried locking the sheet as a read only, and have also looked for VB code to lock my chart with no joy, can anyone help with code to either lock the chart or format it on opening so that it doesnt matter if it gets altered.


    Any help would be greatly appreciated as this is the one thing stopping me from completing a project that has taken me 9 months so far!



Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.” - Rick Osborne