Could anyone expand on this a bit?
If input is entered into column C (range C2:C100), then row cells for columns D, E ,F, H or I must NOT be blank upon save.
Could be that one or more of these row cells are left blank by mistake.
An error msg pops up upon attempt to save and colors each cell yellow that lacks info.
I found this coding in another thread.
Please Login or Register to view this content.
Last edited by Cutter; 08-29-2012 at 10:34 AM. Reason: Added code tags
@ ScottyDo
Welcome to the forum.
Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.
My apologies and thx for your help. I've re-read the rules and understand now how to add code the correct way.
Hello ScottyDo ,
Should the workbook be saved after the cells are colored yellow or stop the save and let the user correct the yellow cells?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith, It should stop the save and the yellow colored cells be filled with input.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks