S sharon.speiser Oct 23, 2003 #1 i would like to create a required field in excel template that user must complete. is this possible?
D Dave Peterson Oct 24, 2003 #2 I find the simplest approach is to use an adjacent cell and format it bold, red. =if(a1<>"","","Please put something in A1") You could also take a macro approach and have it check before the user saves/prints/goes to a different sheet. But I like that formula approach. It's instantaneous (and very easy!).
I find the simplest approach is to use an adjacent cell and format it bold, red. =if(a1<>"","","Please put something in A1") You could also take a macro approach and have it check before the user saves/prints/goes to a different sheet. But I like that formula approach. It's instantaneous (and very easy!).
