A
ajlove20
Hi,
I have a workbook that copies values from a sheet located in multipl
workbooks. In the multiple workbooks I have a code that runs when I tr
to exit the workbook. This code goes through the sheets in the workboo
and asks the user if all values have been entered on the sheets. I
does this through a userform, where the user can click Yes or No.
That code works fine, but when I try to copy the values from the sheet
I get the userforms from the other workbooks.
I was wondering if there was something I could do to not have th
userform come up when copying the value. Any help is appreciated.
Thanks in advance.
a
I have a workbook that copies values from a sheet located in multipl
workbooks. In the multiple workbooks I have a code that runs when I tr
to exit the workbook. This code goes through the sheets in the workboo
and asks the user if all values have been entered on the sheets. I
does this through a userform, where the user can click Yes or No.
That code works fine, but when I try to copy the values from the sheet
I get the userforms from the other workbooks.
I was wondering if there was something I could do to not have th
userform come up when copying the value. Any help is appreciated.
Thanks in advance.
a