HI I have below code which give me little problems. When there is a value in cell D10. a messagebox pop up and ask me to save the invoice , before i can close the workbook. It works ok. If there is no value it close right away. If there is a value it save the worksheet, but dont close the workbook. So basically its works.
I would like that if there is value in cell D10, dont save the worksheet, but dont close the workbook off course..But only save, when i have saved the invoice, as it ask me to do.
Its more that when there will be many invoices, it will take un nesssary time. I am sure it is maybe only a little thing. But i have played around and cant make it work.
And off course the hold idea is that it save without promt the user.
Please have a look at the code.
Sincerely
Abjac
Bookmarks