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

Thanks it works fine!
But there is one glitch. i copied a working macro in my personal.xls but the problem is i have to remember the cell from which the macro has to be performed. is there any way that this can be avoided ie it does not have any problem while performing from any cell

----- Dick Kusleika wrote: ----



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

First, determine if you have a Personal.xls already. Alt-F11 to open th
VBE and Cntrl-R to make sure the Project Explorer window is in view. Loo
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 i
your XLSTART directory. This will insure that Personal.xls is opene
whenever you start Excel. From the Window menu, choose Hide to hid
Personal.xls

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

Now that you have macros in Personal.xls, those macros will be available t
any workbook that is open. Because Personal.xls is in the XLSTART director
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 the
were in the workbook on which you are working. You can use Alt-F8 to brin
up the Macro Dialog and select and run the macros from there. You can put
button on the sheet and assign the macros to the button. You can assign th
macros to toolbar buttons on a custom toolbar

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

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

--
Dick Kusleik
MVP - Exce
www.dicks-clicks.co
Post all replies to the newsgroup

"R. SRIKANTH" <ramasamysrikanth wrote in messag
..
dear MS expert
i had previously posted a query regarding personal and it was answered b
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?
would like to have a step by step proces
and also how it has to be run in excel
thanking guys/gal

R

It's all how you write the macro. Post the macro here and I'll see what can
be done.

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

"R. SRIKANTH" wrote in message
...
Thanks it works fine!
But there is one glitch. i copied a working macro in my personal.xls but
the problem is i have to remember the cell from which the macro has to be
performed. is there any way that this can be avoided ie it does not have any
problem while performing from any cell.

----- Dick Kusleika wrote: -----

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