L
Lucia
I am trying to protect a workbook which has data on
worksheet 1 and a scatter-plot function on sheet2. When
i protect the worksheets, the macros I have written to
select and plot the data on sheet 2 from sheet 1 are
disabled. how can I protect the sheet yet maintain cross-
worksheet macros? I KNOW you can do this from the crappy
film quiz type workbooks you are sent at work!
And proecting the workbook is unsuitable since I intend
lots of users, but only one modifier.
Any help gratefully gratefully received.
worksheet 1 and a scatter-plot function on sheet2. When
i protect the worksheets, the macros I have written to
select and plot the data on sheet 2 from sheet 1 are
disabled. how can I protect the sheet yet maintain cross-
worksheet macros? I KNOW you can do this from the crappy
film quiz type workbooks you are sent at work!
And proecting the workbook is unsuitable since I intend
lots of users, but only one modifier.
Any help gratefully gratefully received.