Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version # in excel
Want to put a version number in an excel spreadsheet - that cannot be
altered. I like the idea of the Custom Properties - but that appears like an end user could change it. I want to include a version number for debugging (so I know which version they are using). Any insight/ideas would be greatly appreciated. BBB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version # in excel
Use a hidden name
With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With -- HTH Bob Phillips "Billy Boone" wrote in message news:Ziese.56327$x96.28775@attbi_s72... Want to put a version number in an excel spreadsheet - that cannot be altered. I like the idea of the Custom Properties - but that appears like an end user could change it. I want to include a version number for debugging (so I know which version they are using). Any insight/ideas would be greatly appreciated. BBB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version # in excel
So how to I got about executing that code?
Then where would I go to view the version number (in the code again). Forgive my ignorance. "Bob Phillips" wrote in message ... Use a hidden name With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With -- HTH Bob Phillips "Billy Boone" wrote in message news:Ziese.56327$x96.28775@attbi_s72... Want to put a version number in an excel spreadsheet - that cannot be altered. I like the idea of the Custom Properties - but that appears like an end user could change it. I want to include a version number for debugging (so I know which version they are using). Any insight/ideas would be greatly appreciated. BBB |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version # in excel
Billy,
In the VBA Editor, add a new module, and use the following code: Sub AddVersionNumber() With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With End Sub Sub ViewVersionNumber() MsgBox "Version: " & Mid(ThisWorkbook.Names("Version").Value, 2) End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Billy Boone" wrote in message news:bugse.57603$_o.14989@attbi_s71... So how to I got about executing that code? Then where would I go to view the version number (in the code again). Forgive my ignorance. "Bob Phillips" wrote in message ... Use a hidden name With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With -- HTH Bob Phillips "Billy Boone" wrote in message news:Ziese.56327$x96.28775@attbi_s72... Want to put a version number in an excel spreadsheet - that cannot be altered. I like the idea of the Custom Properties - but that appears like an end user could change it. I want to include a version number for debugging (so I know which version they are using). Any insight/ideas would be greatly appreciated. BBB |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Version # in excel
You can also use that name in a worksheet
=Version -- HTH Bob Phillips "Chip Pearson" wrote in message ... Billy, In the VBA Editor, add a new module, and use the following code: Sub AddVersionNumber() With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With End Sub Sub ViewVersionNumber() MsgBox "Version: " & Mid(ThisWorkbook.Names("Version").Value, 2) End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Billy Boone" wrote in message news:bugse.57603$_o.14989@attbi_s71... So how to I got about executing that code? Then where would I go to view the version number (in the code again). Forgive my ignorance. "Bob Phillips" wrote in message ... Use a hidden name With ActiveWorkbook .Names.Add Name:="Version", RefersTo:="1.02.100" .Names("Version").Visible = False End With -- HTH Bob Phillips "Billy Boone" wrote in message news:Ziese.56327$x96.28775@attbi_s72... Want to put a version number in an excel spreadsheet - that cannot be altered. I like the idea of the Custom Properties - but that appears like an end user could change it. I want to include a version number for debugging (so I know which version they are using). Any insight/ideas would be greatly appreciated. BBB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving a newer version of Excel using an older version (Excel 97) | Excel Discussion (Misc queries) | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
download trial version excel 2003? can only find trial version 200 | Excel Discussion (Misc queries) | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) |