If you are trying to run the event from Workbook B the code needs to be in
Wbk B.

However, once you start the code you can you can make things happen to other
workbooks:


With Workbooks("A")
.Sheets("XXX").Range("A1")=5
.close True
End With
Close true
end sub

This will change then Save and Close Wbk A, then Save and Close ThisWorkbook.

"Job" wrote:

> I'm trying to implement a App_WorkbookBeforeSave bit of code, but I don't
> understand how to get it to work for any open workbook and have it work
> anytime excel is opened.
>
> Cheers!
>
>
>