ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   TRacking Version Number in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/190110-tracking-version-number-excel-2007-a.html)

DeeJay

TRacking Version Number in Excel 2007
 

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

Bob Phillips

TRacking Version Number in Excel 2007
 
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




Gord Dibben

TRacking Version Number in Excel 2007
 
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




All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com