Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ribap
 
Posts: n/a
Default enable commentaries when is protected


Hello, i need to write commentaries in some cells and also i need to
protect some other cells, the problem is that once i protect some cells
the commentaries get disabled in every cell in the worksheet. What can i
do?

Thanks.


--
Ribap
------------------------------------------------------------------------
Ribap's Profile: http://www.excelforum.com/member.php...o&userid=25382
View this thread: http://www.excelforum.com/showthread...hreadid=388593

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

When you protect the sheet, allow the users to edit objects.

The users will be able to add/delete/change comments. And they'll be able to do
things to other objects, too: pictures, buttons, checkboxes, etc...

Ribap wrote:

Hello, i need to write commentaries in some cells and also i need to
protect some other cells, the problem is that once i protect some cells
the commentaries get disabled in every cell in the worksheet. What can i
do?

Thanks.

--
Ribap
------------------------------------------------------------------------
Ribap's Profile: http://www.excelforum.com/member.php...o&userid=25382
View this thread: http://www.excelforum.com/showthread...hreadid=388593


--

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
How to enable the sort function for a protected sheet lkjing Excel Discussion (Misc queries) 1 June 30th 05 01:18 PM
enable autofilter in a protected worksheet in Excel 97 WooGHeR Excel Worksheet Functions 1 March 25th 05 04:44 PM
How do i enable "Group" & "Ungroup" in a protected sheet Fadi Excel Discussion (Misc queries) 1 March 4th 05 05:37 PM
How to enable font color on protected worksheet? dlterry Excel Discussion (Misc queries) 3 January 28th 05 11:19 PM
How to enable grouping in a protected sheet Ankur Excel Worksheet Functions 2 November 1st 04 07:52 PM


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