Larry

You mention "auto save".

Which version of Excel are you running?

Versions later than 2000 do not have autosave, they have autorecovery which does
not make incremental saves as the older autosave did.

If your code is in the Thisworkbook beforeclose event it won't fire until you
close the workbook.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
'your number generator code here
End Sub

The autosave should not generate a new number.


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 12:37:01 -0700, Larry wrote:

Hi folks, sure appreciate that you are out there to help.
I have a workbook that I use to generate a new sequenced number that I want
to automatically save on closing everytime it is opened by a user. The
autosave add in forces me to select a time interval, I just want it to save
automatically on close so the new number is kept and not inadvertently used
again. any help?? thanks, larry