Sheet not filled propery before save?

  • Thread starter Thread starter pobuckley
  • Start date Start date
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
 
something like.
for each c in selection
if c.value="" then msgbox "go back"
next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top