adding a worksheet causes main userform to corrupt
Wehn adding a worksheet in a macro it corrputs the userform i'm adding one
worksheet then another in succession i have triedseveral differnt methods of
doing this but it keeps corrupting the userform each time.
Am going to keep playing with this as it needs to be ready ASAP but if
anyone has any idea of why this is happening i would be greatful.
P.S. code is hard to transfer as am on differnt machines but currently the
offening lines of code a
If frmMain.chkOutbound.Value = True Then
Set NewSheet1 = worksheets.add
newsheet1.name = "Baseline Data Tx"
End if
|