Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |