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