insert images in a protected worksheet

[Guest]

hello..
please help me..
How do i insert an image in a protected woksheet?

thanks

 

[Ron de Bruin]

hi Kub

When you protect the worksheet
check "Edit Objects" in the list

 

[Guest]

hi Ron de Bruin

it still doesn't work..
i can edit a picture.. but i can't insert a new one.
what am i doing wrong?

thanks.

"Ron de Bruin" escreveu:

 

[Ron de Bruin]

I can do it in excel 2007

I go test it in Excel 2003

 

[Ron de Bruin]

You are right

In Excel 2007 you can do it but not in older versions

You can create a macro to do it if you want.

Unprotect the sheet
call a browse dialog
Insert
Protect

Is that a option for you ?

 

[Guest]

Try inserting it as an "Object", "from file", rather than as a
"Picture"......or, you could copy and paste it.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

ohhh...
thank you

i'll try it...

"Ron de Bruin" escreveu:

 

[Ron de Bruin]

If you need help let me know

 

[Harlan Grove]

In Excel 2007 you can do it but not in older versions ....

Meaning Excel 2007 lacks worksheet protection in the sense of preventing
adding ADDITIONAL objects to a protected worksheet, at least image objects?

Not good. That would mean someone could insert a new image and place it on
top of any image that might already be there. The OP may prefer such
functionality, but I'm thinking of others who might want to prevent
obscuring existing images.

 

[Harlan Grove]

Try inserting it as an "Object", "from file", rather than as a
"Picture"......or, you could copy and paste it.

....

In Excel 2003 the Insert > Object menu entry isn't disabled when a protected
worksheet is active, but Excel won't put an object into it. It'll let you go
through the motions in the Object dialog, but when you click OK, it'll
display an error dialog stating 'Cannont insert object'.

 

[Ron de Bruin]

Hi Harlan

Not good. That would mean someone could insert a new image and place it on
top of any image that might already be there. The OP may prefer such
functionality, but I'm thinking of others who might want to prevent
obscuring existing images.

I agree with you on this

I go check if this is correct that it is working like this in 2007.