View Single Post
 
Old 01-06-2013, 02:28 PM
omahadivision omahadivision is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Oct 2012
Posts: 28
omahadivision is on a distinguished road
Default Way to lock a workbook but still allow moving datapoints on a chart?

Hello,

I am trying to write a macro to make my excel workbook read-only. This would be fairly easy, except that I still want users to be able to move and delete datapoints on a series on a chart, and I want users to still be able to run macros. I don't want data changed or the chart edited in other ways such as resizing or renaming the axises. Optimumly, I could also make it non-read-only by running another macro. How could I make a read-only exception for data labels?

Thanks!

-Dave
Reply With Quote