I have a worksheet with a number of pictures in it. I want to disable
the user from being able to select, move, or delete the pictures in the
worksheet. Anybody have any ideas?

Thanks,
-Abe

right click on the picture and select format picture.

in the protection tab, make sure Locked is checked.

then go to Tools=Protection=Protect sheet

In xl2000 and earlier, make sure objects are selected

in xl2002 and later, make sure you don't allow the user to "edit objects"

finish applying the protection.

--
Regards,
Tom Ogilvy


"Abe" wrote:

I have a worksheet with a number of pictures in it. I want to disable
the user from being able to select, move, or delete the pictures in the
worksheet. Anybody have any ideas?

Thanks,
-Abe

Tom,

Will the VBA code I have still be able to edit, move and delete the
pictures?

-Abe

Tom Ogilvy wrote:
right click on the picture and select format picture.

in the protection tab, make sure Locked is checked.

then go to Tools=Protection=Protect sheet

In xl2000 and earlier, make sure objects are selected

in xl2002 and later, make sure you don't allow the user to "edit objects"

finish applying the protection.

--
Regards,
Tom Ogilvy


"Abe" wrote:

I have a worksheet with a number of pictures in it. I want to disable
the user from being able to select, move, or delete the pictures in the
worksheet. Anybody have any ideas?

Thanks,
-Abe

You can unprotect and protect the sheet using code, so just do that in your
procedures when necessary to work with the pictures.

--
Regards,
Tom Ogilvy


"Abe" wrote:

Tom,

Will the VBA code I have still be able to edit, move and delete the
pictures?

-Abe

Tom Ogilvy wrote:
right click on the picture and select format picture.

in the protection tab, make sure Locked is checked.

then go to Tools=Protection=Protect sheet

In xl2000 and earlier, make sure objects are selected

in xl2002 and later, make sure you don't allow the user to "edit objects"

finish applying the protection.

--
Regards,
Tom Ogilvy


"Abe" wrote:

I have a worksheet with a number of pictures in it. I want to disable
the user from being able to select, move, or delete the pictures in the
worksheet. Anybody have any ideas?

Thanks,
-Abe