Protect
 

I have a worksheet with inserted pictures and data. All I want is that
inserted pictures cannot be highlight and can write where I have the data.

Protect
 

Hi,

Try unlocking all of the cells - Format, Cell, Protection..
And then turn on Sheet Protection - Tools, Protection, Protect Sheet.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MAX" wrote:

I have a worksheet with inserted pictures and data. All I want is that
inserted pictures cannot be highlight and can write where I have the data.

Protect
 

Sorry it didn't work. I can still move my pictures.
Just to tell you that I'm using Excel 2007.

Thanks a lot.

"Shane Devenshire" wrote:

Hi,

Try unlocking all of the cells - Format, Cell, Protection..
And then turn on Sheet Protection - Tools, Protection, Protect Sheet.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MAX" wrote:

I have a worksheet with inserted pictures and data. All I want is that
inserted pictures cannot be highlight and can write where I have the data.

Protect
 

OK
I found how:
When you come to protect sheet you have to uncheck Locked cells and Edit
Objects.

Thanks

"MAX" wrote:

I have a worksheet with inserted pictures and data. All I want is that
inserted pictures cannot be highlight and can write where I have the data.