Macros (Sub routine type) not found, Functions are In XLA

[Andy Kessel]

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]

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)