| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
| How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
| Create dictionary of terms, create first time user site | New Users to Excel | |||
Linear Mode
