I know why the error is happening, it's because once I've created a quote for a customer I save it with a reference number eg 101. The code below changes the ref no on launch, I only want it to change on the sheet name Costing Sheet - Private Hire.xls
Therefore, when I open the file 101 I get the below error message. Do I need and ELSE or IF statement somewhere?
Error message and code below.
[Blocked Image: http://img28.imageshack.us/img28/1803/10300400.png]