how to attach macros to excel permanently - pawan
 

I have few macros which I require frequently. I want to attach them to excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?


Thank you
-Pawan

how to attach macros to excel permanently - pawan
 

Put them all in a new workbook, save the workbook as an add-in (file type of
xla, at the foot of the list). Then install the add-in, menu
ToolsAdd-InsBrowse.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pawan" wrote in message
...
I have few macros which I require frequently. I want to attach them to
excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?


Thank you
-Pawan

how to attach macros to excel permanently - pawan
 

There is also the personal.xls file that can store and make available code.

"Bob Phillips" wrote:

Put them all in a new workbook, save the workbook as an add-in (file type of
xla, at the foot of the list). Then install the add-in, menu
ToolsAdd-InsBrowse.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pawan" wrote in message
...
I have few macros which I require frequently. I want to attach them to
excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?


Thank you
-Pawan

how to attach macros to excel permanently - pawan
 

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the worksheet menubar.



Pawan wrote:

I have few macros which I require frequently. I want to attach them to excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?

Thank you
-Pawan

--

Dave Peterson

how to attach macros to excel permanently - pawan
 

I have added the add-in....but when I open new worksheet, it doesn't show the
macros in the macro list..

"Bob Phillips" wrote:

Put them all in a new workbook, save the workbook as an add-in (file type of
xla, at the foot of the list). Then install the add-in, menu
ToolsAdd-InsBrowse.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pawan" wrote in message
...
I have few macros which I require frequently. I want to attach them to
excel
so that whenever I open excel sheet (whether it is new sheet or already
existing sheet). How should I do it?


Thank you
-Pawan