Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a worksheet with inserted pictures and data. All I want is that
inserted pictures cannot be highlight and can write where I have the data. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Try unlocking all of the cells - Format, Cell, Protection.. And then turn on Sheet Protection - Tools, Protection, Protect Sheet. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MAX" wrote: I have a worksheet with inserted pictures and data. All I want is that inserted pictures cannot be highlight and can write where I have the data. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Sorry it didn't work. I can still move my pictures.
Just to tell you that I'm using Excel 2007. Thanks a lot. "Shane Devenshire" wrote: Hi, Try unlocking all of the cells - Format, Cell, Protection.. And then turn on Sheet Protection - Tools, Protection, Protect Sheet. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MAX" wrote: I have a worksheet with inserted pictures and data. All I want is that inserted pictures cannot be highlight and can write where I have the data. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
OK
I found how: When you come to protect sheet you have to uncheck Locked cells and Edit Objects. Thanks "MAX" wrote: I have a worksheet with inserted pictures and data. All I want is that inserted pictures cannot be highlight and can write where I have the data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect | Excel Discussion (Misc queries) | |||
Protect.... | Excel Discussion (Misc queries) | |||
Add "Protect ALL Sheets" that is the same as "Protect Sheet" | Excel Worksheet Functions | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Can I protect columns w/in a "List" using Protect Sheet? | Excel Discussion (Misc queries) |