| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I enter a comment in a protected worksheet?
I made a worksheet and protected this. The normal working fields are unlocked
and can be used by a third party.What have I to adjust, so a third party can use my worksheet and enter/edit/delete comments? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I enter a comment in a protected worksheet?
In Excel 2002 and later, in the Sheet Protect dialog, check "Edit Objects"
as in Allow all users of this worksheet to Edit Objects. If you or they are using versions earlier than xl2002, then this is not supported. -- Regards, Tom Ogilvy "Jack" wrote in message ... I made a worksheet and protected this. The normal working fields are unlocked and can be used by a third party.What have I to adjust, so a third party can use my worksheet and enter/edit/delete comments? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can I enter a comment in a protected worksheet?
How do you add the "Edit Objects" in VBA? ActiveSheet.Protect password:="mypwd", DrawingObjects:=False Contents:=True, Scenarios:= True Jose -- Jose ----------------------------------------------------------------------- Josee's Profile: http://www.excelforum.com/member.php...fo&userid=1901 View this thread: http://www.excelforum.com/showthread.php?threadid=50529 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add comment in protected worksheet | Excel Worksheet Functions | |||
| Inserting a comment box in a protected worksheet | Excel Discussion (Misc queries) | |||
| Inserting a comment box in a protected worksheet | Excel Worksheet Functions | |||
| How do I insert a comment in a protected worksheet ? | Excel Discussion (Misc queries) | |||
| Insert comment in protected worksheet | Excel Worksheet Functions | |||
Linear Mode
