Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FrankOtter68
 
Posts: n/a
Default Protected worksheet with unprotected cells i.c.w. remarks

I have a worksheet, which is protected. On the sheet there are several
unprotected cells. Other user should have the possibilty to add remarks at
the unprotected cells. But, although the cells are unprotected, it seems not
possible for them to add remarks. The option is light grey (=inaccassible).
Is there another solution to this? I don't want to give them my password for
the sheet.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB
 
Posts: n/a
Default Protected worksheet with unprotected cells i.c.w. remarks

I think when you protect it, you can uncheck the box for objects and this
will enable the users to insert comments (into both locked and unlocked
cells).

There may, however, be other objects on your worksheet that you don't want
to allow access to, so you should play with it a little and see this will
allow access to other things you don't want the user's to have access to.


"FrankOtter68" wrote:

I have a worksheet, which is protected. On the sheet there are several
unprotected cells. Other user should have the possibilty to add remarks at
the unprotected cells. But, although the cells are unprotected, it seems not
possible for them to add remarks. The option is light grey (=inaccassible).
Is there another solution to this? I don't want to give them my password for
the sheet.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i format inserted cells in protected worksheet? Justin Excel Worksheet Functions 0 February 21st 06 04:51 PM
adding comments to unprotected cell/range in protected worksheet gone fishing Excel Worksheet Functions 0 February 8th 06 10:06 PM
How can I use open/close Grouped cells in a Protected Worksheet? Andy Bowshell Excel Discussion (Misc queries) 2 January 16th 06 02:38 PM
Move cursor through all unprotected cells in a protected worksheet Bob Simpson Excel Discussion (Misc queries) 9 November 18th 05 06:50 PM
Unprotecting Cells in a Protected Worksheet Mark F Excel Discussion (Misc queries) 2 December 21st 04 11:13 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"