Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Adding A Global Macro In Excel.
Posted by - NA - on 30 March 2006 05:38 AM
|
|
|
Solution: You can make a macro available to all your workbooks by saving the macro in personal.xls. Another way to make a macro available to all workbooks is to create an Add-in. If you save your workbook as an Add-in, only the macros are saved. However, in this case, the macros are hidden so no one can modify them, or even view them. To do this, write your macro then choose File/Save As. Click the arrow at the right side of the 'Save as type' list box and select Microsoft Excel Add-In (xla). Name your new Add-In and click Save to save it and close the dialog box. Excel will automatically save the Add-In in the correct folder. To use the Add-In, one must choose Tools/Add-In and select the new name. | |
 (148 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)