Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Graphics
I have inserted 26 individual graphics depicting the alphabet (A-Z) to
create hyperlinks to relevant locations in a workbook. Locking the sheet does not protect these graphics which can therefore be accidentlaly erased - even if rather clumsily. Is there a way to lock graphics in Excel as one can lock cells? I am running Excel 2007 but the file is saved for 97/2003 compatibility. TIA for any input. Ed |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Graphics
Using defaul settings, I am not able to delete graphics. What options did you
enable when protecting your sheet? When you protect the sheet, make sure the "Edit objects" obtion is not selected. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ed O'Brien" wrote: I have inserted 26 individual graphics depicting the alphabet (A-Z) to create hyperlinks to relevant locations in a workbook. Locking the sheet does not protect these graphics which can therefore be accidentlaly erased - even if rather clumsily. Is there a way to lock graphics in Excel as one can lock cells? I am running Excel 2007 but the file is saved for 97/2003 compatibility. TIA for any input. Ed |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Graphics
Thanks, Luke. Exactly what I was looking for - bit embarassing though!
Regards, Ed "Luke M" wrote in message ... Using defaul settings, I am not able to delete graphics. What options did you enable when protecting your sheet? When you protect the sheet, make sure the "Edit objects" obtion is not selected. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ed O'Brien" wrote: I have inserted 26 individual graphics depicting the alphabet (A-Z) to create hyperlinks to relevant locations in a workbook. Locking the sheet does not protect these graphics which can therefore be accidentlaly erased - even if rather clumsily. Is there a way to lock graphics in Excel as one can lock cells? I am running Excel 2007 but the file is saved for 97/2003 compatibility. TIA for any input. Ed |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Graphics
Hi, Luke.
I sent a 'thank you' note yesterday. Don't know why it hasn't shown. Ed "Luke M" wrote in message ... Using defaul settings, I am not able to delete graphics. What options did you enable when protecting your sheet? When you protect the sheet, make sure the "Edit objects" obtion is not selected. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ed O'Brien" wrote: I have inserted 26 individual graphics depicting the alphabet (A-Z) to create hyperlinks to relevant locations in a workbook. Locking the sheet does not protect these graphics which can therefore be accidentlaly erased - even if rather clumsily. Is there a way to lock graphics in Excel as one can lock cells? I am running Excel 2007 but the file is saved for 97/2003 compatibility. TIA for any input. Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
row locking, instead of file locking? | Excel Discussion (Misc queries) | |||
Graphics won | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Bug with graphics | Excel Discussion (Misc queries) | |||
Add in to allow to save graphics to JPG | Excel Discussion (Misc queries) |