How do I copy worksheet without vbcode from workbook to workbook

  Desert Andy 14:33 09 Oct 2013
Locked
Answered

Hi

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

Andy

  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

Cheers

  lotvic 12:45 10 Oct 2013
Answer

Useful links,

clear VBA code contents click here

Tutorials, click here

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

Mr

  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

What is ransomware and how do I protect my PC from Petya?

Microsoft Surface Studio – the artist's hands-on review

Original iPhone review

Comment mettre à jour Kodi ?