Microsoft Office Tutorials and References
In Depth Information
COPY THE PERSONAL MACRO WORKBOOK TO ANOTHER COMPUTER
On your co-worker’s computer, follow these steps:
Open Excel.
Open to VBA editor by pressing Alt+F11. If this computer does not already
have a Personal.xls fi le in the Project Explorer, create one by choosing to
record a new macro and specifying that it should be saved in Personal.
xls. When the macro recorder starts, move to a new cell and then stop
recording. This will create the Personal.xls in the proper folder.
Open MyPersonal.xls on this computer.
In the VBA Project Explorer, expand Personal.xls so you can see the
modules entry. Expand MyPersonal.xls so you can see each individual
module.
Drag the modules from MyPersonal.xls into the Modules folder in Personal.
xls (Figure 137).
Close Excel. Reopen Excel. All the macros will have been copied into
Personal.xls on the new computer.
1.
2.
3.
4.
Part
3
5.
6.
Figure 137. You drag modules from
MyPersonal.xls to Personal.xls
on the new computer.
Summary: You can copy macros from your Personal.xls fi le to other
computers.
 
Search JabSto ::




Custom Search