View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default adding a worksheet causes main userform to corrupt

"corrputs the userform" is not self defining. What does that mean? what is
happening to you userform? Are you getting execution errors?

What version of excel are you using?
--
Regards,
Tom Ogilvy

"Magius00" wrote in message
...
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