Change the userform code subs below as follows:
'Cancel button Private Sub cmdCancel_Click() Hide Tag = 0 'add this lbl_Exit: Exit Sub End Sub Private Sub cmdExecute_Click() Tag = 1 'change this Hide lbl_Exit: Exit Sub End Sub
Change the userform code subs below as follows:
'Cancel button Private Sub cmdCancel_Click() Hide Tag = 0 'add this lbl_Exit: Exit Sub End Sub Private Sub cmdExecute_Click() Tag = 1 'change this Hide lbl_Exit: Exit Sub End Sub
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com