Hello,
I'm looking how to protect a graph that I have in a sheet. I don't want the people using it to be able to modify it.
Thanks a lot.
S.
Hello,
I'm looking how to protect a graph that I have in a sheet. I don't want the people using it to be able to modify it.
Thanks a lot.
S.
Hello Szermat,
You have 2 options. One is to protect the Worksheet. The Locked property is set true as the default for any Chart, and Worksheet Cells also. If the user is to enter data on the worksheet, you will have to Unlock the cells you want the user access.
The second option is to save your Chart as a Chart Sheet in the Workbook and lock that sheet only. The user can view the chart but not change anything. It also eliminates the hassle of Unlocking Worksheet Cells.
Sincerely,
Leith Ross
Thanks a lot ;-)
S.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks