Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Enabling comments on a protected worksheet

I have a protected worksheet, where I want the user to be
able to add comments on certain cells. Is it possible to
enable comments on a protected worksheet?

Sam
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Enabling comments on a protected worksheet

Posted By Norman Harker

In Excel 2002 you can use:

Tools Protection Protect Sheet
Put check against Edit Objects

That allows users to both insert comments and edit them.


In Excel 1997 and 2000 you can use:

Tools Protection Protect Sheet
Remove check from Objects

That allows users to both insert comments and edit them.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"S Phadke" wrote in message ...
I have a protected worksheet, where I want the user to be
able to add comments on certain cells. Is it possible to
enable comments on a protected worksheet?

Sam



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
Enabling Spell Check in Protected Worksheet Barb Reinhardt Excel Discussion (Misc queries) 2 May 10th 10 08:49 PM
Insert Comments on a Protected Worksheet cinnie New Users to Excel 1 March 4th 10 11:49 PM
Adding comments into a protected worksheet Sean Excel Discussion (Misc queries) 6 July 26th 06 06:24 PM
Protected worksheet and comments Jack Excel Discussion (Misc queries) 1 January 26th 06 01:55 PM
Enter comments in a protected Excel worksheet SUE D Excel Worksheet Functions 1 September 21st 05 04:57 PM


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