Create own add-in

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
hidi said:
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.
 
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 Tools>Macros>Record 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 (Windows>Unhide)


--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Back
Top