S
Sandy
Is there any way I can prevent the 'Workbook_BeforeClose' code module
running at the point where I have inserted the asterisks
Sub NewName()
Application.ScreenUpdating = False
Application.EnableEvents = False
'other code
ThisWorkbook.SaveCopyAs filename:="C:\Users\Sandy\Documents\NewBook.xls"
ThisWorkbook.Close SaveChanges:=False
************
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
Thanks
Sandy
running at the point where I have inserted the asterisks
Sub NewName()
Application.ScreenUpdating = False
Application.EnableEvents = False
'other code
ThisWorkbook.SaveCopyAs filename:="C:\Users\Sandy\Documents\NewBook.xls"
ThisWorkbook.Close SaveChanges:=False
************
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
Thanks
Sandy