LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupt Excel Worksheet Sim Excel Discussion (Misc queries) 0 April 27th 09 06:55 PM
on your main page click on the worksheet name and be taken to it chiefrockeruk Excel Worksheet Functions 2 May 20th 08 05:40 PM
Replacing a corrupt worksheet Steve Excel Worksheet Functions 0 September 17th 07 11:20 PM
adding several worksheet cells onto a main worksheet oxicottin Excel Worksheet Functions 2 September 20th 06 08:07 PM
Access from add_in userform to main template userform.... Ajit Excel Programming 1 November 18th 04 05:15 PM


All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"