| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Script useable by like workbooks
I'm just learning VBA for use with Excel 2007.
What is the best way to make a script available to other workbooks of a similar type? Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Script useable by like workbooks
See help on Personal Macro Workbook for making macros available for
all workbooks. Also consider storing your macros in a new workbook and saving that workbook as an Add-in. I consider the Add-in route as the best way. Gord On Mon, 14 Nov 2011 07:01:06 -0800 (PST), John Menken wrote: I'm just learning VBA for use with Excel 2007. What is the best way to make a script available to other workbooks of a similar type? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| saveing a spreadsheet as html want to keep the outline useable | Excel Discussion (Misc queries) | |||
| Run .vbs script on client workbooks | Excel Programming | |||
| Creating Useable Index | Excel Discussion (Misc queries) | |||
| script to send data from worksheet to multiple workbooks | Excel Programming | |||
| combining 3 columns into useable date | Excel Worksheet Functions | |||
Hybrid Mode
