Hi


I have attached two files one with user form another without


A:-Marketing Plan Name
B:-Related Initiatives
C:-Region
D:-Start Period
E:-End Period
F:-Business Unit

I have above coulumns in my Excel sheet i would like make the sheet without entreing data into these filed should show an error while saving the file

"please enter all mandatory filed"

without user form, i want the same machanism showing error "please enter all mandatory filed" to test file as in mktg plan

Can any one help on this

Rajesh