auto close workbook

[swain.s]

what code would i have to put in VBA (data) to close the data workbook when i
close the (test) workbook or visa versa

 

[מיכ×ל (מיקי) ×בידן]

Check the Event-Macro: Workbook_BeforeClose
Micky

 

[מיכ×ל (מיקי) ×בידן]

To be more precise - use the hereunder code in the TEST WB:
====================================
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Workbooks("DATA.XLS").Close SaveChanges:=False
End Sub
==========
Micky

 

[swain.s]

i get

run-time error '9':

suscript out of range