LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Data Validation Blank Cells

Hello!

I have created a worksheet with all the cells locked except the ones I want
the information in and the sheets protected.

The user can then tab from one cell to the other entering information, I
would like to make it so they have to enter information in the cells or the
warning is set off stating that they need to enter information. How can I do
this?

Thank you.
Lou
 
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 on blank cells LOU Excel Worksheet Functions 1 May 9th 07 09:43 PM
Data Validation with Blank Date Gos-C Excel Worksheet Functions 2 August 4th 06 01:02 PM
Adding a blank in Data Validation List? Pheasant Plucker® Excel Discussion (Misc queries) 10 March 20th 06 03:06 PM
Loading Column Data with blank Rows into Data Validation Box ExcelMonkey Excel Worksheet Functions 3 October 13th 05 06:09 PM
How do I set up a drop down validation to ignore any blank cells? MLP Excel Discussion (Misc queries) 1 August 3rd 05 11:20 PM


All times are GMT +1. The time now is 07:20 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"