LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amadis
 
Posts: n/a
Default protecting sheet blocking comment creation


Hello Everyone, I'm set to release a budget sheet across my district,
however, I've stumbled into a little last minute problem.

I have to lock certain cells on this work sheet. Mostly the ones that
have the formulas that work out the budget variances. However, a big
part of this sheet is the use of comments (used to explain budget
variances). When I protect the sheet, I can no longer add comments.

Is there anyway to fix this?

THANKS A TON

-Amadis


--
Amadis
------------------------------------------------------------------------
Amadis's Profile: http://www.excelforum.com/member.php...o&userid=31831
View this thread: http://www.excelforum.com/showthread...hreadid=520404

 
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
Selecting Last Sheet Bonbon Excel Worksheet Functions 17 February 22nd 06 04:16 PM
I can't edit comment in shard spread sheet. apple Excel Discussion (Misc queries) 2 February 20th 06 10:26 PM
Sheet Protecting password Nick Excel Discussion (Misc queries) 1 June 30th 05 12:43 AM
data from one sheet to several in sequential order! firecord New Users to Excel 6 June 22nd 05 05:10 PM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 05:08 AM.

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"