Run Macro On Closing Workbook

[Papa_Don]

Group,

I need to close a second workbook when the primary workbook closes. I've tried the following macro:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks(propRestran).Activate
ActiveWorkbook.Close
End Sub

When closing the primary workbook (where the macro is housed), the second workbook (named 'propRestran') does not become active and it does not close. What is it that I'm missing or doing wrong?

In advance, thanks for your assistance.

Don

 

[JackDanIce]

It might be you're missing speech marks and the file extension. Also, you shouldn't need to activate the workbook to close it. Try:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks("propRestran.xlsx").Close
End Sub

Adjust string in blue as required.