I'm sure you could use a worksheet_Change event to react to any change in A1 of
a certain sheet.

But your requirements are a bit sketchy. Is the workbook just supposed to be
saved -- or is to be saved using the value in A1 as its name? What folder gets
the new file?

You may find you get better suggestions if you provide more details.

Lost wrote:

Ok I was wondering if there is a code for excel 07 that will save the
workbook after someone enters information?

If you enter 4567 in cell a1 and then select another cell it will
autosave

--

Dave Peterson