Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003
I have a range of unlocked cells in a protected sheet(select unlocked cells only is checked) in a protected workbook (protect structure only is checked) that I would like to allow the user to insert comments into. Can anyone tell me how to accomplish this? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When you protect the sheet, only protect contents, don't protect Objects.
-- Regards, Tom Ogilvy "Jeff Higgins" wrote in message ... Excel 2003 I have a range of unlocked cells in a protected sheet(select unlocked cells only is checked) in a protected workbook (protect structure only is checked) that I would like to allow the user to insert comments into. Can anyone tell me how to accomplish this? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you Tom for your speedy reply.
I appreciate it very much. Moments ago I found an answer to my question at the links posted below, then I came back here and you had already answered my question, Thanks. Anyway I thought I might paste links below in hopes they might help someone else with a similar question. Link to page concerning Excel comments: http://www.mvps.org/dmcritchie/excel/ccomment.htm Link to page where I found answer to my question http://groups-beta.google.com/group/...55fe068fc07429 "Tom Ogilvy" wrote: When you protect the sheet, only protect contents, don't protect Objects. -- Regards, Tom Ogilvy "Jeff Higgins" wrote in message ... Excel 2003 I have a range of unlocked cells in a protected sheet(select unlocked cells only is checked) in a protected workbook (protect structure only is checked) that I would like to allow the user to insert comments into. Can anyone tell me how to accomplish this? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Tom
I'm stuggling with the same problem. Isn't there another way of doing this? When I set DrawingObjects:=False then other objects (e.g. logo at the top of the page) can be deleted. Regards, Claude "Tom Ogilvy" schrieb: When you protect the sheet, only protect contents, don't protect Objects. -- Regards, Tom Ogilvy "Jeff Higgins" wrote in message ... Excel 2003 I have a range of unlocked cells in a protected sheet(select unlocked cells only is checked) in a protected workbook (protect structure only is checked) that I would like to allow the user to insert comments into. Can anyone tell me how to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unlocked Cells in Protected Sheet | Excel Worksheet Functions | |||
How can I format unlocked cells when the work sheet is protected | Excel Discussion (Misc queries) | |||
Allowing comments in unlocked cells within protected sheet | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) |