Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drawing on Protected Sheet
I have a sheet setup that has 50% of the cells locked.
I need to be able to allow the user to draw arrows over the cells that are not locked. Basically the Right side of the sheet is for adding comments. So I need to be able to draw on it. Any suggestions would be greatly appreciated. TIA Robert |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drawing on Protected Sheet
Robert
If using Excel 2002 or newer version you can checkmark "edit objects" when you protect the sheet. Earlier versions will probably require you to unprotect, do the drawing, then re-protect. Gord Dibben MS Excel MVP On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" wrote: I have a sheet setup that has 50% of the cells locked. I need to be able to allow the user to draw arrows over the cells that are not locked. Basically the Right side of the sheet is for adding comments. So I need to be able to draw on it. Any suggestions would be greatly appreciated. TIA Robert |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drawing on Protected Sheet
That did it.
THANKS!!!! "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Robert If using Excel 2002 or newer version you can checkmark "edit objects" when you protect the sheet. Earlier versions will probably require you to unprotect, do the drawing, then re-protect. Gord Dibben MS Excel MVP On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" wrote: I have a sheet setup that has 50% of the cells locked. I need to be able to allow the user to draw arrows over the cells that are not locked. Basically the Right side of the sheet is for adding comments. So I need to be able to draw on it. Any suggestions would be greatly appreciated. TIA Robert |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drawing on Protected Sheet
This works in XL97 as well, but allows one to draw on any part of the
sheet, even the protected areas....... Vaya con Dios, Chuck, CABGx3 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Robert If using Excel 2002 or newer version you can checkmark "edit objects" when you protect the sheet. Earlier versions will probably require you to unprotect, do the drawing, then re-protect. Gord Dibben MS Excel MVP On Sun, 11 Jun 2006 15:09:49 GMT, "Robert" wrote: I have a sheet setup that has 50% of the cells locked. I need to be able to allow the user to draw arrows over the cells that are not locked. Basically the Right side of the sheet is for adding comments. So I need to be able to draw on it. Any suggestions would be greatly appreciated. TIA Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected sheet spell check | Excel Discussion (Misc queries) | |||
Down arrow moves cursor to top of worksheet when sheet protected | Excel Worksheet Functions | |||
Apply Validation on a protected sheet | Excel Discussion (Misc queries) | |||
Protected Sheet Message | Excel Discussion (Misc queries) | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) |