View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Magius00 Magius00 is offline
external usenet poster
 
Posts: 6
Default 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