Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt Excel Worksheet | Excel Discussion (Misc queries) | |||
on your main page click on the worksheet name and be taken to it | Excel Worksheet Functions | |||
Replacing a corrupt worksheet | Excel Worksheet Functions | |||
adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
Access from add_in userform to main template userform.... | Excel Programming |