Moving Macros to Personal.xls

[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,

 

[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
(e-mail address removed)

 

[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

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!