TRacking Version Number in Excel 2007

D

deejay

I want to put a version number in my workbook/sheet. How do I do that?

Let say I want my version number of my final sheet to be V1.1 before I send
to users, it needs to be shown on the top of each sheet. =version returns
?NAME

Help

DJ
 
B

Bob Phillips

You need to maintain it, so what will control this version number? Will a
user input it when they feel like it, will it be updated when the workbook
is opened/saved, or what?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
G

Gord Dibben

Same answer as yesterday.

Excel has no method of keeping track of "versions".


Gord Dibben MS Excel MVP
 
Top