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
|