R

If I understand you correctly, these are the steps that I believe you need
to take.

First, determine if you have a Personal.xls already. Alt-F11 to open the
VBE and Cntrl-R to make sure the Project Explorer window is in view. Look
at all the projects in the Explorer and see if any are named Personal.xls.
If you find one, skip the next step.

To create Personal.xls, open a blank workbook and save it as Personal.xls in
your XLSTART directory. This will insure that Personal.xls is opened
whenever you start Excel. From the Window menu, choose Hide to hide
Personal.xls.

Back in the VBE, insert a new module into the Personal.xls project. Copy
your macros from the other projects into this module. Delete the macros
from the other project after they're copied. Save Personal.xls so you don't
lose those macros.

Now that you have macros in Personal.xls, those macros will be available to
any workbook that is open. Because Personal.xls is in the XLSTART directory
it will start whenever Excel is started. Because Personal.xls is hidden,
you won't see it when you start Excel, but you shouldn't need to see it.

You can run the macros in Personal.xls just like you would run them if they
were in the workbook on which you are working. You can use Alt-F8 to bring
up the Macro Dialog and select and run the macros from there. You can put a
button on the sheet and assign the macros to the button. You can assign the
macros to toolbar buttons on a custom toolbar.

The only difference between macros in Personal.xls and one's in the current
workbook comes when you try to run a macro from Personal.xls from within a
macro in the current workbook. The first option you have is to use the
method that Bob suggested (and that I prefer). Another option is to set a
reference to Personal.xls from within the current workbook (VBE - Tools -
References). If you set a reference, the macros in Personal.xls act like
any macro in the project, that is, you run them by typing their name or by
using the Call keyword.

If you need further clarification on any of the above, please ask.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"R. SRIKANTH" <ramasamysrikanth wrote in message
...
dear MS experts

i had previously posted a query regarding personal and it was answered by
Mr. Bob Phillips.
i am a lay user so i require a step-by-step procedure for this query.
after recording a macro with a file what are the steps to be taken? i
would like to have a step by step process
and also how it has to be run in excel.

thanking guys/gals