Hi All,

I'm new to this forum and have a question, I hope you can help.

I am using Tushar Mehta's AutoChart Add-In (http://www.tushar-mehta.com/excel/so...art/index.html) to automatically set the Y-Axis of my histogram from a cell values calculated in an adjacent sheet. This works fine until I password protect the sheet the chart is in. I have to password protect this sheet for regulatory reasons.

Does anyone know of a way round this using AutoChart or another method. I've never used VBA before but will give anything a go to find a solution.

Many thanks in advance,
David