| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect Sheet but allow pictures
Can I protect a worksheet but allow the users to insert pictures?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect Sheet but allow pictures
Hi,
Choose Tools, Protection, Protect Sheet, and check Edit objects. Then if the user wants to insert a picture they must use the Insert, Object command. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: Can I protect a worksheet but allow the users to insert pictures? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect Sheet but allow pictures
That didn't seem to work. When I inserted the object it appeared as on icon,
not the picture itself. I couldn't find any editing options to change it from the icon to the picture. "Shane Devenshire" wrote: Hi, Choose Tools, Protection, Protect Sheet, and check Edit objects. Then if the user wants to insert a picture they must use the Insert, Object command. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: Can I protect a worksheet but allow the users to insert pictures? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect Sheet but allow pictures
Hi,
I was using the first tab in which case you create the picture and it shows up. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: That didn't seem to work. When I inserted the object it appeared as on icon, not the picture itself. I couldn't find any editing options to change it from the icon to the picture. "Shane Devenshire" wrote: Hi, Choose Tools, Protection, Protect Sheet, and check Edit objects. Then if the user wants to insert a picture they must use the Insert, Object command. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: Can I protect a worksheet but allow the users to insert pictures? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Protect Sheet but allow pictures
Got it to work. Thank you!!
"Shane Devenshire" wrote: Hi, I was using the first tab in which case you create the picture and it shows up. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: That didn't seem to work. When I inserted the object it appeared as on icon, not the picture itself. I couldn't find any editing options to change it from the icon to the picture. "Shane Devenshire" wrote: Hi, Choose Tools, Protection, Protect Sheet, and check Edit objects. Then if the user wants to insert a picture they must use the Insert, Object command. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Melissa K" wrote: Can I protect a worksheet but allow the users to insert pictures? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pictures on excel sheet | Excel Discussion (Misc queries) | |||
| Can I allow insertion of pictures into a protected excel sheet? | Excel Discussion (Misc queries) | |||
| Need to transfer sheet + pictures to multiple computers | Links and Linking in Excel | |||
| Protect Workbook Vs Protect Sheet | New Users to Excel | |||
| Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
