View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default 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