How do I copy worksheet without vbcode from workbook to workbook

  Desert Andy 14:33 09 Oct 2013


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 2013

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 2013

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 2013

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 2013

Many thanks for the help

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

Elsewhere on IDG sites

OnePlus 6 review

Best art and design exhibitions in 2018

MacBook Pro keyboard issues and other problems

E3 2018 : dates, conférences de presse, billets et plus