Locking Graphics

E

Ed O'Brien

I have inserted 26 individual graphics depicting the alphabet (A-Z) to
create hyperlinks to relevant locations in a workbook. Locking the sheet
does not protect these graphics which can therefore be accidentlaly erased -
even if rather clumsily.

Is there a way to lock graphics in Excel as one can lock cells?

I am running Excel 2007 but the file is saved for 97/2003 compatibility.

TIA for any input.

Ed
 
L

Luke M

Using defaul settings, I am not able to delete graphics. What options did you
enable when protecting your sheet?

When you protect the sheet, make sure the
"Edit objects" obtion is not selected.
 
E

Ed O'Brien

Thanks, Luke. Exactly what I was looking for - bit embarassing though!

Regards,

Ed
 
E

Ed O'Brien

Hi, Luke.

I sent a 'thank you' note yesterday. Don't know why it hasn't shown.

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top