Moving Macros to Personal.xls

  • Thread starter Syed Zeeshan Haider
  • Start date
S

Syed Zeeshan Haider

Hello Experts,
I have Excel 97 Pro on Win98SE.

I have macro in an Excel file. How can I move it to Personal.xls?

Thank you,
 
N

Nick Hodge

Syed?

Open the file with the code you wish to copy. Open the VBE (Alt+F11) and
navigate in the project explorer, to the 'module' below the entry of the
workbook from which you want to copy the code. Double click on it and copy
the code.

Navigate to the module below the entry for the personal.xls. Double click
on it and copy the code into the resultant pane.

Save all workbooks. The code will now also be in your personal.xls
workbook.

The above presumes you have a personal.xls and it has modules. If not, post
back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
S

Syed Zeeshan Haider

Syed?

Open the file with the code you wish to copy. Open the VBE (Alt+F11) and
navigate in the project explorer, to the 'module' below the entry of the
workbook from which you want to copy the code. Double click on it and copy
the code.

Navigate to the module below the entry for the personal.xls. Double click
on it and copy the code into the resultant pane.

Save all workbooks. The code will now also be in your personal.xls
workbook.

The above presumes you have a personal.xls and it has modules. If not, post
back
Click to expand...

Thank you, Nick! It solved the problem.

I have been trying to copy the macro to Personal.xls by myself but could
never figure out this simple thing. In fact, I have been trying to do it in
MS Word style :)

Thanks again!
 
Top