Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 30th 04, 07:09 AM
Kevin
 
Posts: n/a
Default Heps to design Locked/Unlocked cells in protected worksheet

Download it from http://www.addintools.com

The Cell Lens Of Locked&Unlocked render and change the background color of
cells according to their lock/unlock state: the locked cells to gray, the
unlocked cells to blue. Assist has also offered a Quick Lock button to lock
the selected range at once and a Quick Unlock button to unlock immediately.
Now you are very clear about which cells are locked and which cells are
unlocked. Just cancel this Cell Lens, the background color will be restored.

Cell Lens Of Data Type render and change the background color of cells
according to their data type: Text to yellow, Number to blue, Date&Time to
green ... Just cancel this Cell Lens, the background color will be restored.
Converting Data Type could recognize these date format like 2004-12-31,
20041231 and will convert them to the locale format in your computer. It
could convert data of cells to Text, Number or Date&Time type.

If you merge some cells in Excel, just the data of first cell could be
maintained and the data of other cells will be destroyed! Safety Merge of
AddinTools Assist to merge the selected cells and maintain all data. Smart
Unmerge to unmerge the selected cells and the data in every cell will be
split into several cells!

Virtual Screen Rulers help you to align the rows and columns in worksheet.
It will draw a colored horizontal line under the active row in a worksheet,
and draw a colored vertical line on the right of the active column.

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
Is it possible to sort a protected worksheet? Phyllis Excel Discussion (Misc queries) 8 January 6th 05 04:45 PM
Unprotecting Cells in a Protected Worksheet Mark F Excel Discussion (Misc queries) 2 December 21st 04 11:13 PM
How can I activate cell shading in a protected worksheet? unprotect cell shading Excel Discussion (Misc queries) 1 December 8th 04 07:31 AM
How can I merge unlocked cells in a worksheet that has been protec NeedMergeHelp Excel Discussion (Misc queries) 2 December 7th 04 01:20 AM
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 12:59 PM


All times are GMT +1. The time now is 09:56 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017