Look in the ThisWorkbook module for the before_save event

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cmac" wrote in message
...
Is there a way to require that a particular cell be populated prior to
saving
an Excel file (one cell is text and one is a date field)? We are using a
spreadsheet to collect data from users that is later used to feed an
Access
database and need to be sure that the source file has these two key cells
populated.

Thank you -