LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KG
 
Posts: n/a
Default Data validation, cell protection or other method?

I have used data validation to set parameters for valid data entry and I have
also used cell protection to prevent any type of data entry. What I am trying
to do in this instance is to prevent data entry but, instead of the standard
message that pops up when using cell protection, I want to display a
customized message such as:

Data for these fields must be entered in "Project Assumptions"

Can Data validation be used to prevent data entry of any kind or do I need
to look for a VBA solution?
 
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
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 12:08 PM
Duplicate data in a cell... The Outlaw Dozy Wales Excel Worksheet Functions 2 December 15th 04 12:31 PM
how to add two data validation lists to a single cell? Mike Peter Excel Worksheet Functions 1 December 8th 04 08:22 PM
sending data from one cell to another (not using copy & paste) Charlie Payne Excel Worksheet Functions 3 December 6th 04 03:28 PM
data validation on sth else [email protected] Excel Worksheet Functions 1 November 3rd 04 01:52 PM


All times are GMT +1. The time now is 03:53 PM.

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"