Graphics in Excel

[3d]

If I have an embedded jpg graphic in eXcel is there a way I can lock it so it cant be deleted?

Thanx

 

[Iridium]

Protect the sheet with a password should work (Tools>Protection>Protect Sheet)

Chris

 

[3d]

This cannot b done this way as I need to access the sheet and enter data on it I have protected cells within the jobbut as the grphic is embedded it isnt within a cell

 

[Iridium]

On 2002-10-10 09:11, 3d wrote:
This cannot b done this way as I need to access the sheet and enter data on it I have protected cells within the jobbut as the grphic is embedded it isnt within a cell

Not quite sure what you mean but you should still be able to enter data into individual cells on a protected sheet if you format them as unprotected i.e. Format>Cells -Protection tab and uncheck the 'locked' box

 

[3d]

Some cells are protected using coding this was the only way it could be done for the project that i was doing at the time for other reasons, but since the project was completed it has been found that a graphic which is on the page was deleted i was just seeing if there was a way that i could lock that graphic to the page to stop it happening again so I need to see if it is possible without protecting the sheet but thankyou for your help anyways

regards

 

[Tom@CPC]

Also, when you protect the sheet, only protect it for Objects. Deselect Contents etc and you will be able to enter data.

HTH, Tom

 

[3d]

thanx did that with the objects works a treat

thankyou for your help you guys another thing to add to my notebook!