Copying Macros

[jwaltman]

How would I copy macros from 1 sheet in a folder to another sheet in
different folder? I have an end of the month folder and have i
separated into months and tried copying from Jan. to Feb but, th
macros didn't copy. :confused

 

[Don Guillett]

It might help if you told us your version of excel ___xl95, xl97, xl2002
and copy/paste your macro here.

 

[Gord Dibben]

First, let's establish what you mean by "sheet"

An *.xls File is a Workbook.

A Workbook contains one or more Worksheets.

Macros are in a Workbook, either as modules in Thisworkbook or Worksheets or
as General or Class Modules.

If you know what type of macro, we can assist further.

Gord Dibben Excel MVP

 

[Dave Peterson]

Another option.

Don't copy the code into multiple workbooks.

Instead, separate the code from all the workbooks. If you need to run the
macro, open the single workbook with the code and Tools|Macro|macros... and run
it from there. Then when you decide you have to tweak the code, you don't have
to fix it in multiple spots.

(This might even work depending on what your macros do!)