This is (almost) EXACTLY what I need....but I just a little help on one part of the VBA code (who I have to thank VoG over on the Mr.Excel forums for figuring out)
I am making an Expense spreadsheet for work and I want it so that they cannot enter in an amount for their expense unless they enter their date, their name, the reason for the expense, the client they were working on that generated the expense, and the type of expense. So columns H & J are the cells I want them unable to enter in data for unless they select from they enter information in the cells on the same row in columns B, C, D, E, and H.
I was able to modify the code so it would protect the cells in columns I & K and it works perfectly but ONLy if column D is filled in .....but I need to also have it check columns B, C, E, and H as well.
So how do I change
to include making columns B,C, E, and H also have text entered?
I need to have this finalized for a presentation on Monday morning....so any late night or weekend help would be GREATLY appreciated!
Bookmarks