Thx for the help.
I managed to finish the rest and tested it out and attached it here.
All works fine except 1 button can't perform the command its assigned to because of the code in this workbook:
Private Sub Workbook_Before Close(Cancel As Boolean)
Confirm1.Show
'When button "Co Back to workbook" is clicked in the Confirm1 Form
'this workbook.close needs to be canceled so I can go back to to the workbook.
End Sub
So I got a commandbutton1 in the Confirm1 Userform that is assigned with:
Private Sub CommandButton1_Click()
Confirm1.Hide
End Sub
When I push this button the workbook closes because its still in the 'Private Sub Workbook_BeforeClose' code.
Is there a way to cancel that code? Something like this?
Private Sub CommandButton1_Click()
Confirm1.Hide
Workbook.close Cancel
End Sub
Thx
Bookmarks