Hi Nap,

Sorry, I misinterpreted your intent in your post. It looks like Dave P
& yourself are figuring out your problem re the "work book open"
issue.
http://excelforum.com/showthread.php...=workbook+open


I'm guessing that the above will also provide a solution to the issue
of
"updating Row 14, Col 11, in the ActiveWorkbook"
b/c if still needed you can change the relevant line
"Application.ActiveWorkbook.ActiveSheet.Cells( 14, 11) = InvoiceName" to
refer to the appropriate workbook.

Good luck,
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

Nap Wrote:
Broro183,

I am putting the macro that updates the Invoice number into MY
personal.xls, NOT the customer's. Nor am I sending my personal.xls to
the customer.

If you look at my code, you will see that I am updating Row 14, Col
11, in the ActiveWorkbook. (The code has a bug in it at the moment in
that as it stands, it will put the invoice number into R14,C11 of the
personal.xls.

Once I get an answer to my question, I will fix this bug.

So, in the end, the customer will get a clean spreadsheet with no
macros in it.

Cheers,
Nap.


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=525580