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

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)



"deejay" wrote in message
...

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

Same answer as yesterday.

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


Gord Dibben MS Excel MVP

On Thu, 5 Jun 2008 01:27:00 -0700, deejay
wrote:


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