Where in the world I change the file version? Thisworkbook.names("fileversion")

[actjfc]

Excel friends,

I inherited a workbook that when I run this VBA code Thisworkbook.names("fileversion") I get "Version 3". Now, I am supposed to change it to "Version 4". Where in the menu or what VBA code do I use to change it? I am using Excel 2013.

Thanks for your help!

 

[mole999]

so the save stamps version3 in the title when its saved ? currently

 

[Trebor76]

Hi actjfc,

Seems like it may be a named range. Click the Name Manager option in the Defined Names tab of the FORMULAS ribbon and see if it's there (and modify it if it is).

HTH

Robert

 

[mole999]

one word of caution, make changes on a copy. I've done versioning in the past to stop people renaming files, so they only could use original versions

 

[actjfc]

Thank you so much! Yes, it was a constant name range. I found it!. mole999, yes I am working on something related to "tracking" versions. However, maybe it needs a new post to get some ideas.