adding a worksheet causes main userform to corrupt

[Guest]

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 are:

If frmMain.chkOutbound.Value = True Then
Set NewSheet1 = worksheets.add
newsheet1.name = "Baseline Data Tx"
End if

 

[Tom Ogilvy]

"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?

 

[Guest]

2003

have found thats it's not just on the sheet i was adding but happend later
as well when adding another sheet. have found no other point except for when
it creates the new worksheet

 

[Tom Ogilvy]

I haven't heard of such a relationship and I couldn't find anything in the
knowledge base.

Perhaps you can use better terms to search with than I did

http://support.microsoft.com/

 

[Guest]

Unfortutnly i haven't found anything in the knowladgebase. Then again i
haven't found anything through googling for it either. NOrmaly i would assume
it was my code but since it happens when the opperation to add a sheet occurs
no matter the method used i'm stuck.

If anyone has any ideas to tryplease let me know