Hi all,
I am now working on a data collection sheet and would need some helps from experts here, please kindly gives some advises.
I create a worksheet and want others to fill in structure design parameters (length, width, distance between two objects, etc). To better explain where I am interesting in so I insert pictures for illustration. I also protect the sheet because I don't want the users know my formula or edit items.
The question is that I also need users to insert picture/excel files in that protect sheet, if I don't click the "Edit Object" option when I protect the sheet, users could not insert files I request, however if I do select the "Edit Objects" option, user could insert files but they could also edit pictures I originally put for illustration.
Is there a way that I could make the sheet being protected, pictures I inserted cannot be moved/edited, but users could still insert pictures/files?
Thanks for your help in advance.
- Owen
I am now working on a data collection sheet and would need some helps from experts here, please kindly gives some advises.
I create a worksheet and want others to fill in structure design parameters (length, width, distance between two objects, etc). To better explain where I am interesting in so I insert pictures for illustration. I also protect the sheet because I don't want the users know my formula or edit items.
The question is that I also need users to insert picture/excel files in that protect sheet, if I don't click the "Edit Object" option when I protect the sheet, users could not insert files I request, however if I do select the "Edit Objects" option, user could insert files but they could also edit pictures I originally put for illustration.
Is there a way that I could make the sheet being protected, pictures I inserted cannot be moved/edited, but users could still insert pictures/files?
Thanks for your help in advance.

- Owen