Transferring Modules

[Submersed]

Hi,

I was wondering if it is possible to transfer code that is in a module activated by a button into a sheet?

many thanks

 

[schielrn]

Why not just call the code in the sheet? You can call sub routines within the sheet code.

 

[Submersed]

The problem is...I copy a few sheets and make a new workbook with them..then i send this workbook to someone but they can't use the macro's because they are all in the modules on the original workbook...So i thought if they are in the sheets wouldn't that work??

 

[schielrn]

I'm not positive that the code would transfer with the copy. I know that code on sheets can be picky at times on what you can do. Sometimes the code has to be in a module to work properly. You can export modules and e-mail them the module and then they can import it into the workbook. There may even be a way through VBA to export a module, but I do not know it.

 

[Submersed]

ok no worries...I'll try and do something

 

[Jon Peltier]

Why not send the entire workbook?

 

[Norie]

Why not create a copy of the workbook, then delete the unneeded worksheets from the copy and send that.

The code should be intact if you do that.

 

[Submersed]

is there some code that will copy the enitre workbook then??

when I just copy all the sheets into a new workbook...the modules don't go along with it...

 

[Jon Peltier]

You can manually Save As, or make a copy in Windows Explorer. Or in code:

ActiveWorkbook.SaveAs "C:\temp\Copy1.xls"

or

ActiveWorkbook.SaveCopyAs "C:\temp\Copy2.xls"

SaveAs changes the active workbook to Copy1.xls, while SaveCopyAs keeps the original workbook as the active workbook.