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
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
> > >
> > >
>
>
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
> > >
> > >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks