EXCEL 03

Hello Tom,
I hope you enjoyed your Excel training session with us.

To answer your question, you can indeed lock images whilst keeping the actual cells unlocked. By default, all cells and images are considered "locked," but to actually use this locked status, you also have to use the menu option: Tools > Protection > Protect Sheet. If you do this, everything in the worksheet will be locked. However, if you wish to keep the cells unlocked, you must first select the cells you wish to unlock (in your case, select all the cells), then choose Format > Cells... and in the Protection tab, untick the "Locked" tickbox. Now when you protect the sheet, the cells you have chosen will stay unlocked, but the rest of the items will be protected.

I hope this resolves your question. If it has, please mark this
question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer