How to copy two pages into same new workbook???

nona

Guest

Posts: n/a

25th Nov 2003

I've used the following commands to make a sheet appear automaticly into
a new workbook. How can I make page1(=Blad1) and page3(=Blad3) appear
in the same new workbook?

Private Sub CommandButton1_Click()
Save.Hide
Blad1.Copy
Opslaan.Show
End Sub

Thanks

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

« Locating file in another directory | Excel 97 and network document »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1	u473	Microsoft Excel Programming	1	9th Sep 2008 05:14 PM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook	burl_rfc	Microsoft Excel Programming	1	1st Apr 2006 08:48 PM
Is there away to keep Excel from opening a copy of an already opened workbook and the pages not be at 100% but	Marc	Microsoft Excel New Users	1	13th Mar 2006 01:51 PM
How can I copy a cell from one page to all pages of a workbook?	=?Utf-8?B?Sm9obiBR?=	Microsoft Excel Worksheet Functions	2	12th Apr 2005 08:32 PM
Copy a range of cells in an unopened workbook and paste it to the current workbook	topstar	Microsoft Excel Programming	3	24th Jun 2004 12:50 PM