Lots of people do this kind of stuff by putting the macros in a workbook
(usually named personal.xls) and stored in Excel's StartUp folder.

Each time excel opens, it'll open this workbook, too. And all the macros will
be available.



ezil wrote:

Can I place the macro independent of worksheet? (from desktop) Every time to
run a macro I have to open a workbook (or) (it open automatically when
pressing macro
button) I reserved one workbook for recording macros only.

--

Dave Peterson