This file might be a help:
http://www.bygsoftware.com/examples/...Properties.zip

The workbook has a family of VBA routines to help you create, amend, and
delete Custom Document Properties

It's in the "Administration Utilities" section on page:
http://www.bygsoftware.com/examples/examples.htm

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"phil in evansville indiana"
wrote in message
...
can i have version numbers on a spreadsheet. when i close the sheet, can
excel append a new version number so i can keep old copies?