auto close workbook
 

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

auto close workbook
 

Check the Event-Macro: Workbook_BeforeClose
Micky


uk" wrote:

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

auto close workbook
 

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


"מיכאל (מיקי) אבידן" wrote:

Check the Event-Macro: Workbook_BeforeClose
Micky


uk" wrote:

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