Hi Gordon,
I am using 2003, I went to tools add ins and there was an add in called
autosave, I enabled it and "autosave" is available as an optiomn. with this
enabled, each workbook opened had a module for autosave in the code section?
if it looks like a duck . . . It is labled autosave not autorecovery. A bit
of a mystery to me. I'll try adding your code to my workbook and see how she
fares. My deepest thanks for your time and help. larry

"Gord Dibben" wrote:

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