![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
Hi Dave,
I doubt that you can. What you could do is implement code that ensures the attributes you want to enforce are re-applied whenever the chart and/or worksheet is either updated, printed, opened or saved.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
![]() |
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
![]() |
FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
![]() |
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |