How do I copy worksheet without vbcode from workbook to workbook

  Desert Andy 14:33 09 Oct 13


I would like to copy a worksheet across to another workbook, but I don't want to copy the vb code contained within the sheet. Is this possible and if so how do I do it.

Many thanks


  AroundAgain 23:48 09 Oct 13

Hi I assume you mean some sort of spread sheet? Maybe you could give a bit more information, someone may be able to help you better

If it's Excel, and you mean you want to just copy one work sheet to another, then this link should help you and you should find it very simple to do


  lotvic 12:45 10 Oct 13

Useful links,

clear VBA code contents click here

Tutorials, click here

Excel vba easy, click here Excel forum for Qs and help, click here


  Picklefactory 13:39 11 Oct 13

It's no problem to just copy the values and cell formats, but if the VBA code is enabling the sheet to perform functions, then obviously those functions will not be available without the associated code, so you can copy the data, but the sheet may not function in the same way. Is that what you mean?

  Desert Andy 13:14 14 Oct 13

Many thanks for the help

This thread is now locked and can not be replied to.

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…