Error Checking before Save

[Leslie67]

What event should you put error checking of an Excel sheet into if you want to make sure that all cells are filled in before the sheet is saved?

Is it even possible?

I have some lazy people working here who will fill out as little as possible and I want to be able to force them to fill out all cells.

Thanks

 

[longhair]

Leslie67,
try the WorkbookBeforeSave event.
hth
regards,
dave

 

[Leslie67]

Oh good lord...

I was so "Sheet" concentrated that I forgot the Workbook!

Thanks for the kick in the pants, Dave...

Regards,
Leslie