disable cells
Hi There,
I just want to know how to disable certain cell/column/row in an excel sheet without using protect sheet option. I have Microsoft Offices 2000 installed on my PC. Thanking in advance Gaensh |
Something I have used in the past (although not as secure as protection -
which is also not all that secure) is to use cell validation, set the Allow: to Custom, then in the formula enter < this essencially does not allow any data entry to a cell, unless of course the validation is removed. Simon "Ganesh" wrote: Hi There, I just want to know how to disable certain cell/column/row in an excel sheet without using protect sheet option. I have Microsoft Offices 2000 installed on my PC. Thanking in advance Gaensh |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com