I have an invoice put together in excel and I have a VBA code to update the date in the invoice, if that range is empty, and another code that updates the invoice number from a text file stored on the network.
Everything works like a charm but when that master invoice get's saved as, the VBA goes with it. meaning if invoice 1004 gets saved, the next time it is opened it is invoice 1005. I don't want that to happen, I want it to stop running when the workbook name changes.
Thanks, Im' stumped with this one.
Bookmarks