#1   Report Post  
confused
 
Posts: n/a
Default validation

when using cell validation's it works fine for protecting cells when ppl
enter data in the correct range , however if someone hightlights a few rows
and clear contens it deletes all the data, anyway to stop this so only the
listed data can be entered
  #2   Report Post  
Otto Moehrbach
 
Posts: n/a
Default

Unlock those cells into which you want the user to enter data via Data
Validation (Format - Cells - Protection tab - uncheck the "Locked" box).
Just those cells. Then protect the sheet (Tools - Protection - Protect
Sheet).
The user can still copy/paste something into those specific cells (the
unlocked cells) and wipe out the Data Validation, but he cannot select one
or more rows and delete their contents. He can select the Data Validation
cell and clear it and that would clear the contents of that cell but not the
Data Validation. Post back if this doesn't fill your needs. HTH Otto

"confused" wrote in message
...
when using cell validation's it works fine for protecting cells when ppl
enter data in the correct range , however if someone hightlights a few
rows
and clear contens it deletes all the data, anyway to stop this so only the
listed data can be entered



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
Data Validation Mike R Excel Discussion (Misc queries) 11 May 6th 05 02:38 AM
Data Validation gbeard Excel Worksheet Functions 1 May 3rd 05 09:09 AM
data validation gbeard Excel Worksheet Functions 2 May 2nd 05 09:57 PM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 26th 05 12:50 AM
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 11:48 PM


All times are GMT +1. The time now is 01:00 AM.

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"