My code is jumping workbooks

[carsto]

I have the following code in ThisWorkbook Object:

Please Login or Register  to view this content.

A user had the workbook containing this code open.
Then opened a workbook from a customer which contained NO code.
Upon trying to close the customer's workbook she was given the message "Blank Row are not allowed before closing please delete Row(s): "

She closed our workbook containing this code, and then was able to close the customer's workbook.

Why would the code in ThisWorkbook apply itself to another workbook?

[shg]

All unqualified range references refer to ranges on the activesheet of the activeworkbook.

You should qualify references with ThisWorkbook.SheetX.Range(whatever), where SheetX is the code name (the name seen in the Project Explorer window) for the worksheet.

[carsto]

why would sheet code or workbook code refer to anything other than the sheet or workbook it is in?

[shg]

It would be pretty limited in versatility if it couldn't. There would be no such thing as add-ins, for example.