| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using macros in an external worksheet
Thx - that's what I've been looking for.
"Dave Peterson" wrote: I would save the file as an addin so the workbook will be hidden when it opens. But then I'd have to give the users (myself???) some way of running those procedures. For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) ======= If you're going to save this addin with others and you have UDF's called from cells in a worksheet, then I'd save the addin (DCH3Utils.xla) in a common location -- a shared folder and tell the users to install the addin using the UNC path name (not a mapped letter). If that's not possible, then I'd tell the users to save it to the same folder name: C:\MyAddins\dch3utils.xla Then tools|addins|browse and install it from there. dch3 wrote: What is the best way to setup Excel if I need to access macros in an external worksheet and run them in a variety of worksheets? I tried saving them in a .xls worksheet and then setup Excel to open the worksheet when the app opens, but the worksheet is always displayed. Should I save the worksheet as a *.xla and then add it as an add-in? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to easily (!) load Macros from external files on demand? | Excel Discussion (Misc queries) | |||
| macros for copying external data to Excel | Excel Discussion (Misc queries) | |||
| External Excel Macros | Excel Programming | |||
| dynamically loading external macros, on the fly | Excel Programming | |||
| Disabling Splashscreens and macros from external aps | Excel Programming | |||
Threaded Mode
