Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Adding comments to unprotected cell in a protected sheet

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Adding comments to unprotected cell in a protected sheet

If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Adding comments to unprotected cell in a protected sheet

Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave

"Dave Peterson" wrote:

If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Adding comments to unprotected cell in a protected sheet

shapes, pictures, controls, ...

Dave wrote:

Thank you that works.

What else will this allow the user to edit on the protected sheet? I am not
sure what is included under "Objects".

Thanks
Dave

"Dave Peterson" wrote:

If you allow objects to be edited, you can add them.

But maybe that's too much to allow?

Dave wrote:

Is there a way to add comments to an unprotected cell in a protected
worksheet? The option to insert a comment is not available in the insert
menu even when the cursor is on the unprotected cell.

Thanks
Dave


--

Dave Peterson


--

Dave Peterson
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
jump to active cell in other sheet . mongkolkorn Excel Discussion (Misc queries) 12 June 19th 07 07:30 PM
Copying a work sheet cell reference as relative not absolute? Velson Excel Discussion (Misc queries) 4 January 7th 06 01:46 PM
Allow unprotected cells to spell check after sheet is protected Numberonekraut (Hans) Excel Worksheet Functions 1 September 15th 05 07:55 PM
Clicking Cell Link Changes Cell on Another Sheet nshah Excel Discussion (Misc queries) 1 August 31st 05 01:50 AM
Tab key don't work in unprotected cells in a protected sheet Chad Excel Discussion (Misc queries) 0 August 16th 05 02:00 AM


All times are GMT +1. The time now is 11:26 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"