Good afternoon all
I have two workbooks,,,, 'Driver Database' (DD) and 'Driver Standard Routes' (DSR)..
In the userform on the DD i have a command button to close the userform and open the DSR Sheet... this works OK...
On the DSR I have command button to clost the DSR, this works OK,, but I also need it to close the DD sheet... I have been trying various version of the code, including switching the two lines around,, but cannot get it to close the DD sheet
Any help would be very much appreciated
Many thanks JT
Private Sub cmdclose_Click()
Unload Me
ActiveWorkbook.Close SaveChanges:=True
Workbooks("Driver Database.xlsm").Close SaveChanges:=True
End Sub
Bookmarks