Protect Sheet>Edit Objects except textbox

Hi,

I am working on a report template.

In the template there is a Textbox and a picture file (macro to auto-resize)

I would like to lock the textbox from resizing/moving but allow input of text.

I found that this can partly work by protecting sheet and uncheck allow edit objects.

However, when i do that, I am unable to select the picture file, is there a way to only lock the textbox from resizing and moving.

Any help is very much appreciated.

REgards,
JT

Below is the macro created to insert picture (modification of some threads here. Thanks!) and protect sheet.

Please Login or Register  to view this content.

Welcome to the forum, tianah.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.