I have a spreadsheet that is used for invoicing customers. I created a master invoice sheet which has a searchable combobox on it. I duplicate the master invoice sheet and name the new sheet something different each time. In a month the user will create 60-90 invoices for various customers. When the new invoice sheet is created or upon activation of that sheet it writes the sheet name and file name to an external customer data file. The external customer data file only contains customer data in it and is used for the searchable combobox which pulls customer data back into the invoice.
The original layout had the customer data in the same sheet as the invoice and it worked fine. Now that I put it externally it'll work for a while then suddenly the customer data file seems to lock up and so does the invoice sheet. This only occurs when changing the customer name in the combobox.
I've been working on this for the past couple weeks and I'm now stuck. If anyone has any suggestions I'd really appreciate it.
If you create a directory called "temp" on the root of the C drive and you drop the two files in there you should run fine. Once you start to test the combobox that's where it'll fail.
Appreciate any suggestions you have.