Workbook close VBA

Hi,
Could anyone offer some help with the following. I have a shared workbook which has a number of worksheets. The format of each worksheet and the data is very similar. Each worksheet contains a date.

Every working day each worksheet is updated by a different person - this includes updating the date to be the same as the previous working day.

Once all of the worksheets have been updated the spreadseet has to be mailed to a client. I want a message to be displayed to the user prior to the spreadhseet being closed when each of the spreadsheets has been updated, in otherwords the date field on each of the spreadsheets = the date of the previous working day.

Thanks in advance.
Simon

Originally Posted by sgrech

Hi,
Could anyone offer some help with the following. I have a shared workbook which has a number of worksheets. The format of each worksheet and the data is very similar. Each worksheet contains a date.

Every working day each worksheet is updated by a different person - this includes updating the date to be the same as the previous working day.

Once all of the worksheets have been updated the spreadseet has to be mailed to a client. I want a message to be displayed to the user prior to the spreadhseet being closed when each of the spreadsheets has been updated, in otherwords the date field on each of the spreadsheets = the date of the previous working day.

Thanks in advance.
Simon

Has nobody got any ideas on this? I didn't think that it was that taxing.

Simon