Sheet not filled propery before save?

P

pobuckley

Hi there

I have a sheet which has entries for each person. If the Person i
maked as Billed then the bill for each month goes into the relevan
cell on that row.

Can I run a macro (maybe when I go to save the file) which will tell m
that not every cell was filled and that I should go back and fill i
the relevant cells.

Cheers
Padrai
 
D

Don Guillett

something like.
for each c in selection
if c.value="" then msgbox "go back"
next
 
Top