Beforeclose problem

[lightsandsirens]

I have a macro that runs before close. It updates a couple of cell values. It works fine unless I have another workbook open and attempt to close all documents by closing excel. I get an out of range error because there is no sheet of the name in the other document I have open.

Basically it seems that the beforeclose works on the active workbook, not the workbook it is saved in. I don't want to hard code the workbook filename in as I will be creating dozens of duplicates for individual users.

[shg]

Perhaps you could post the code.

[romperstomper]

If you want the code to work on the workbook containing the code, use ThisWorkbook to refer to the workbook. The name of the file won't matter.