| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros (Sub routine type) not found, Functions are In XLA
Okay, I created an XLA with two modules. One has functions, one has
Subroutine type macros. Installed them. When I go to insert function, the functions are there. But when I go to run Macro, the macros are not. Help! Andy Kessel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macros (Sub routine type) not found, Functions are In XLA
You have to give the user a way to get to those subroutines.
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) Andy Kessel wrote: Okay, I created an XLA with two modules. One has functions, one has Subroutine type macros. Installed them. When I go to insert function, the functions are there. But when I go to run Macro, the macros are not. Help! Andy Kessel -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macros with functions | Excel Worksheet Functions | |||
| Macros or functions | Excel Programming | |||
| Macros and IF Functions | Excel Programming | |||
| preserving type library references when distributing macros | Excel Programming | |||
Linear Mode
