Auto add number when opening file

[scottnunavut]

I am creating a purchase order template and want the Purchase Order (PO) number to automatically update by one when I open it. The code below is for a button that updates the number by one, then saves it so next time it will be updated. I want the macro do do the same thing, but automatically when I open the file so I don't have to press the button. I'm new to this, so I think I may have extra code in there, but it works.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[KOKOSEK]

Maybe this:

Please Login or Register  to view this content.

of course into Workbook code.

[scottnunavut]

That did not work

[alansidman]

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

[jolivanes]

In addition to alansidman's questions, did you read the last sentence of KOKOSEK's answer on where to put the code?
Did you also change the sheet reference?

[KOKOSEK]

@scottnunavut:
If you original code works under button_click (You've said that), this should works as well.
Of course, there are only changes on reference to sheet (Sheets("name")) as I don't know where locations of ranges are.

[scottnunavut]

Thanks for all you help but I've gotten nowhere. I've uploaded the file with the NEW PO button working. Again, when it is clicked, the number in D10 automatically +1 (moved it from 3 to 4), and then it saves so when I open it again it the number 4 is in D10. So, as is the file is usable, but it is more convenient to have the file auto +1 and then save so I don't have to remember click the button. thanks.

[KOKOSEK]

There is no code in Workbook code.
It can't increment this value automatically if you do not put code where it should be put.

Check attached file. It automatically increase D10 after each opening.

[scottnunavut]

GOT IT! Thanks all. Now how to I mark this thread as solved?