Forum Discussion
How to allow user to add/modify shapes to protected worksheets
I'm developing an interactive grid for users to draw various designs, but protect the sheets so they can't accidentally change the sheet arrangement or code ranges, however I would like to allow them...
The following might work as a workaround:
Insert drawing element rectangle
Click on the rectangle, click the following in the context menu:
Format Author Shape - Colors and Lines - Fill Color - Fill Effects - Graphics.
Then you could insert your graphic file into the rectangle as a background image.
is a bit more complicated, but you can also use the Edit objects option when the sheet is protected.
Is just a thought 🙂
Hope I was able to help you with this info.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
thanks for the suggestion but once I protect the sheets, the insert shapes icon is dimmed out so the user can't add anything.