Create own add-in
 

Hi

I have a relatively simple macro that i would like to run on many different
spreadsheets sperately. Is there a way of creating an add-in that i can see
this macro when i open excel in one of the tool options.

Shaheed

Create own add-in
 

"hidi" wrote in message
...
Hi

I have a relatively simple macro that i would like to run on many
different
spreadsheets sperately. Is there a way of creating an add-in that i can
see
this macro when i open excel in one of the tool options.

Shaheed

If you save your macro in personal.xls it will always be available when you
start Excel.

Create own add-in
 

What is perosnal.xls? Do i need to create it?

"Lorne" wrote:

"hidi" wrote in message
...
Hi

I have a relatively simple macro that i would like to run on many
different
spreadsheets sperately. Is there a way of creating an add-in that i can
see
this macro when i open excel in one of the tool options.

Shaheed

If you save your macro in personal.xls it will always be available when you
start Excel.

Create own add-in
 

Personal.xls is located in the XLStart directory, and is used to store
macros and
things that you want to be available to all workbooks, whenever you start
Excel.

You can create it by
- goto ToolsMacrosRecord New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (WindowsUnhide)


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"hidi" wrote in message
...
What is perosnal.xls? Do i need to create it?

"Lorne" wrote:

"hidi" wrote in message
...
Hi

I have a relatively simple macro that i would like to run on many
different
spreadsheets sperately. Is there a way of creating an add-in that i
can
see
this macro when i open excel in one of the tool options.

Shaheed

If you save your macro in personal.xls it will always be available when
you
start Excel.