G Guest Apr 28, 2005 #1 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?
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?
A Andy Wiggins Apr 29, 2005 #2 This file might be a help: http://www.bygsoftware.com/examples/zipfiles/CustomDocumentProperties.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"
This file might be a help: http://www.bygsoftware.com/examples/zipfiles/CustomDocumentProperties.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"
