insert images in a protected worksheet

K

kub

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:
 
R

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 ?
 
C

CLR

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
 
H

Harlan Grove

Ron de Bruin said:
In Excel 2007 you can do it but not in older versions ....
Click to expand...

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.
 
H

Harlan Grove

CLR said:
Try inserting it as an "Object", "from file", rather than as a
"Picture"......or, you could copy and paste it.
Click to expand...
....

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'.
 
R

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.
Click to expand...

I agree with you on this

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