How to allow user to add/modify shapes to protected worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2264466%22%20slang%3D%22en-US%22%3EHow%20to%20allow%20user%20to%20add%2Fmodify%20shapes%20to%20protected%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264466%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20developing%20an%20interactive%20grid%20for%20users%20to%20draw%20various%20designs%2C%20but%20protect%20the%20sheets%20so%20they%20can't%20accidentally%20change%20the%20sheet%20arrangement%20or%20code%20ranges%2C%20however%20I%20would%20like%20to%20allow%20them%20to%20be%20able%20to%20add%20shapes%20%26amp%3B%20arrows%20%26amp%3B%20move%20them%20around%20%26amp%3B%20change%20the%20sizes.%20However%2C%20I%20do%20have%20buttons%20on%20the%20sheet%20that%20I%20DON'T%20want%20them%20to%20modify%2C%20but%20when%20I%20allow%20%22edit%20objects%22%20in%20the%20protection%20settings%2C%20it%20also%20allows%20them%20to%20edit%20the%20buttons%2C%20which%20may%20cause%20issues%20if%20they%20accidentally%20delete%20them.%20Is%20there%20code%20to%20allow%20SOME%20objects%20to%20be%20editable%20but%20not%20ALL%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2264466%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2264529%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20allow%20user%20to%20add%2Fmodify%20shapes%20to%20protected%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264529%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F861198%22%20target%3D%22_blank%22%3E%40Cyndie_Birdsong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20following%20might%20work%20as%20a%20workaround%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EInsert%20drawing%20element%20rectangle%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EClick%20on%20the%20rectangle%2C%20click%20the%20following%20in%20the%20context%20menu%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EFormat%20Author%20Shape%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22VIiyi%22%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20Colors%20and%20Lines%20-%20Fill%20Color%20-%20Fill%20Effects%20-%20Graphics.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThen%20you%20could%20insert%20your%20graphic%20file%20into%20the%20rectangle%20as%20a%20background%20image.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3Eis%20a%20bit%20more%20complicated%2C%20but%20you%20can%20also%20use%20the%20Edit%20objects%20option%20when%20the%20sheet%20is%20protected.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIs%20just%20a%20thought%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 to be able to add shapes & arrows & move them around & change the sizes. However, I do have buttons on the sheet that I DON'T want them to modify, but when I allow "edit objects" in the protection settings, it also allows them to edit the buttons, which may cause issues if they accidentally delete them. Is there code to allow SOME objects to be editable but not ALL? Thanks!

2 Replies

@Cyndie_Birdsong 

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.