Setting Y-Axis with Cell Values in Protected Sheet
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,
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1