Open a workbook on closing another

[Dragondude]

Here is a simple request. It was a very simple thing to do in Excel back before VBA but I can't find it in VBA.

I want to open a workbook when I click on the close "X" symbol on another workbook.

I am sure there must be an "On_click" function associated with the "X".

[mgs73]

I think Workbook_BeforeClose will do what you want:

Please Login or Register  to view this content.

[Dragondude]

I have tried that but it doesn't seem to work. Where should I be putting it?

[Dragondude]

Found it. ThisWorkbook code area.