moving macro

[SherryJ]

In our office one lady uses a macro, we need another to use the same. How do
we move the macro from one computer to another.
I do no know much(alost nothing) about macro's so please if you have any
help i woill greatly appreciate it.

 

[Joel]

there a lots of ways. The trcik is finding the macro. The macro could be in
the workbook or it could be in a file called personal.xls

If in workbook:

1) First get to the VBA editor. Right click on Tab at botttom of worksheet
(normally sheet1) and select code.
2) On right side of screen is Project - VBA Project. The macro may be in
several places.
a) In a module
b) In one of the sheets
c) ThisWorkbook

3) Double click in the VBAProjectt each of these items until the macro is
found.
4) Then highlight code and copy.

5) Open second workbook the same as first and paste code.

If in personal.xls look in this directory
C:\Program Files\Microsoft Office\OFFICE11\XLSTART

Different version of Office havve diffferent numbers. May be in Offfice10.
e-mail the personal.xls file from one computer to a 2nd computer and save in
the same directory.

 

[SherryJ]

Thank You, Thank You
I got it moved

there a lots of ways. The trcik is finding the macro. The macro could be in
the workbook or it could be in a file called personal.xls

If in workbook:

1) First get to the VBA editor. Right click on Tab at botttom of worksheet
(normally sheet1) and select code.
2) On right side of screen is Project - VBA Project. The macro may be in
several places.
a) In a module
b) In one of the sheets
c) ThisWorkbook

3) Double click in the VBAProjectt each of these items until the macro is
found.
4) Then highlight code and copy.

5) Open second workbook the same as first and paste code.

If in personal.xls look in this directory
C:\Program Files\Microsoft Office\OFFICE11\XLSTART

Different version of Office havve diffferent numbers. May be in Offfice10.
e-mail the personal.xls file from one computer to a 2nd computer and save in
the same directory.