I need my workbook to save the changes and rename the file (to the name
in cell A1) when I close the workbook ... is it possible to automate
this?

I use the workbook for invoice generation, cell A1 is the unique number
and I have a clerk who keeps overwriting the previous file by simply
answering "Yes" to the prompt "Do you want to save the changes" without
renaming the file.

Many thanks for your help

Tony


--
y_not
------------------------------------------------------------------------
y_not's Profile: http://www.excelforum.com/member.php...o&userid=19947
View this thread: http://www.excelforum.com/showthread...hreadid=523844