Re: $$Excel-Macros$$ How to copy sheet to new book without sheet module code?

[ashish koul]

Melina

see if it helps

try this link once you copied the sheet to new workbook the delte the code
of the worksheets. or instead of copying the sheet,  copy the data in the
sheet and add a new sheet to new workbook and paste the data in it

http://www.ozgrid.com/VBA/delete-sheet-code.htm

On Thu, Jun 9, 2011 at 5:47 AM, Mel  wrote:

> I copy specific sheets from one book into a new book but I don't want
> any VBA code in the new book. One sheet, however, has code in the
> sheet module. How can I copy it without the code or remove the code in
> the destination book?
>
> For the copy, I'm simply using...
>   Sheets(Array(sShtName1, sShtName2, sShtName3, sShtName4)).Copy
>
> Assume sShtName4 has the sheet code.
>
> Thanks,
> Melina
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ How to copy sheet to new book without sheet module code?

[Mel]

I copy specific sheets from one book into a new book but I don't want
any VBA code in the new book. One sheet, however, has code in the
sheet module. How can I copy it without the code or remove the code in
the destination book?

For the copy, I'm simply using...
   Sheets(Array(sShtName1, sShtName2, sShtName3, sShtName4)).Copy

Assume sShtName4 has the sheet code.

Thanks,
Melina

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel