saving

  • Thread starter Thread starter Lost
  • Start date Start date
L

Lost

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
 
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.
 
Back
Top