• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code to save file with User defined Version No

Cammandk

Member
I have a budget file which has a Defined name "Version No". (Starts as 1.0 - Sheet1.A2)
When the file is saved via worksheet button I need the User to be prompted to accept the current Version No or to revise the Version No. The version No is part of the filename that is saved. If they revise the Version no the value in the defined name should also be updated.

Appreciate any help with this.
DK
 
Back
Top