Tom,
See the recent post "Save Command".

NickHK

"Tom McD" wrote in message
...
Please can anyone tell me how to automatically save a file
as the text I enter in the heading of the sheet for e.g.
cell a1 to a3 I have entered STock Valuation and I would
like to close the file and it would automatically save it
as Stock Valuation. Thanks again everyone.