Unprotect Shape

[Utterly Bamboozled]

Hi I've inserted a basic shape and assigned a macro to it on my worksheet. I can't work out how to unprotect this shape (hence enabling the use of the macro button) whilst keeping the rest of the worksheet protected.

Thanks in advance for your help!

 

[ayazgreat]

Unprotect your sheet, and right click on on shape and select format shape, click properties and uncheck lock. (Excel 2007 and 2010)

 

[Utterly Bamboozled]

Sorry ayazgreat are you sure there's a properties section in the format shape menu? I've got Fill/Line Colour/Line Style/Shadow/3D Format/3D Rotation/Picture/Text Box - none of which have any protection options...

 

[ayazgreat]

Yes I am sure, after the Size and before the Textbox there is a properties.

 

[Utterly Bamboozled]

Thanks ayazgreat, worked it out.

Cheers!

 

[Utterly Bamboozled]

Yes I am sure, after the Size and before the Textbox there is a properties.

Sorry ayazgreat, whilst I have been able to unprotect my object the macro still doesn't work when the sheet is protected saying, 'The cell or chart that you are trying to change is protected and therefore read only'.

Any ideas on what else I have to do to enable the macro whilst the sheet is protected?

Regards,

UB

 

[ayazgreat]

Ok, then unprotect your sheet and during the protection again and before giving password , mark check in "Edit Object" under the header "Allow all user of this worksheet to"

 

[Utterly Bamboozled]

No this still didn't work...

 

[GlennUK]

Sorry ayazgreat, whilst I have been able to unprotect my object the macro still doesn't work when the sheet is protected saying, 'The cell or chart that you are trying to change is protected and therefore read only'.

Any ideas on what else I have to do to enable the macro whilst the sheet is protected?

Regards,

UB

It sounds like the macro is enable alright, but that your macro operations are trying to change something in a protected sheet. Is that what's happening? If so, unprotect the sheet at the start of the macro, and reprotect it at the end.

 

[Utterly Bamboozled]

Thanks GlennUK, this works well now.