LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default How do I add comments to a protected sheet?

1. un-protect the sheet
2. makes the changes
3. re-protect the sheet.
--
Gary''s Student - gsnu200774


"PNI-dz" wrote:

This worksheet is shared for multiple users and is protected so format can
not be changed. Need ability to add comments to certain columns with drop
down lists. Comment icon is not available when protected.

 
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
Show Comments on Protected Sheet Sarah Excel Discussion (Misc queries) 4 March 23rd 07 08:03 AM
adding comments to protected sheet DMT New Users to Excel 1 October 10th 06 01:47 AM
How to add comments/colours to cells in a protected sheet Nousj Excel Discussion (Misc queries) 2 June 21st 06 01:58 PM
Inserting Comments into Protected sheet TJAC Excel Discussion (Misc queries) 1 March 20th 06 06:32 PM
Adding comments to unprotected cell in a protected sheet Dave Excel Discussion (Misc queries) 3 February 8th 06 10:59 PM


All times are GMT +1. The time now is 03:36 PM.

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

About Us

"It's about Microsoft Excel"