benong
08-25-2010, 07:01 PM
hi,
I created a userform in workbook 1.
The input data from userform will be added to workbook 2.
I've added to the script:
Application.ScreenUpdating = False
Whenever i encounter problem executing the script, the workbook 2 will open and stay on screen which the user can see the data.
Maybe mess with it and worst of all, save & replace the original data!
Is there a method of not displaying the workbook 2, irregardless of what type of error i may encounter in the script?
I created a userform in workbook 1.
The input data from userform will be added to workbook 2.
I've added to the script:
Application.ScreenUpdating = False
Whenever i encounter problem executing the script, the workbook 2 will open and stay on screen which the user can see the data.
Maybe mess with it and worst of all, save & replace the original data!
Is there a method of not displaying the workbook 2, irregardless of what type of error i may encounter in the script?