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

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

adding a worksheet causes main userform to corrupt
 

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" wrote:

"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

adding a worksheet causes main userform to corrupt
 

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/

--
Regards,
Tom Ogilvy

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

"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

adding a worksheet causes main userform to corrupt
 

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