Image & Combo Box on a protected worksheet 1

[sunnytahir]

To any one who knows better.

Dear Sirs,
I have some object & combo box & an image control on a worksheet which is protected.
the problem is that when the user changes the value of combo box the image picture does not change.
if i unprotect the worksheet the user can change the other
objects placed on the sheet.
so please help how i can protect the other objects on the
sheet. and the image and combo box should not protect.

thanks.
tahir

 

[dyarwood]

Right click on the image/combobox and click on format control

From here go into the protection tag

Untick the locked tick box

Protect your sheet again and your combobox and image will not be protected.