This can be done using an on open command. This will be in the visual basic editor under thisworkbook.

Now there are ways you could probably do it with a formula or even having a button that says "New Invoice" which you would just attach the middle of the code to it.

Let me know if this is what you are looking for.

Thanks