I'm trying to close a second file that opens just fine with the master file I want, but I can't get it to work. Anyone got any ideas? Code below. Thanks!!
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Set bdrwb = ActiveWorkbook
Workbook.Activate "BDR Sales People - Areas & Values.xls"
MsgBox "activated other workbook"
dataWB.Activate
ActiveWorkbook.Close
bdrwb.Activate
template = Right(ActiveWorkbook.Name, 12)
' If template = "TEMPLATE.xls" Then
ActiveWorkbook.Close False
' End If
HideSheets
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Set bdrwb = ActiveWorkbook
Workbook.Activate "BDR Sales People - Areas & Values.xls"
MsgBox "activated other workbook"
dataWB.Activate
ActiveWorkbook.Close
bdrwb.Activate
template = Right(ActiveWorkbook.Name, 12)
' If template = "TEMPLATE.xls" Then
ActiveWorkbook.Close False
' End If
HideSheets
End Sub