ExcelBanter - View Single Post

NoviceDeveloper

Dave,

It works like a champ.

Thanks,

"Dave Peterson" wrote:

I'm confused.

Did you use VBA or VB to create your addin?

If you used VBA within excel to create the procedures, then it sounds like you
understand correctly.

NoviceDeveloper wrote:

Thanks Dave,

I will try this. But let me understand it properly:

1) In my .xla file, where the VB program is, I add the code to create the
menu bar which is the part of the shell where you indicate "In a general
module..."
2) Then, in the file where I import the .xla file, I use the code to call
the create and remove menu functions which is the part of the shell where you
indicate "Under ThisWorkbook..."

Is this correct?
--
Thanks,

"Dave Peterson" wrote:

I think most would either give the users a toolbar or add icons/options to an
existing toolbar.

Here's how I create that toolbar on the fly:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

NoviceDeveloper wrote:

Hi,
How do I register or expose a function (in a Visual Basic program created
with the Excel Visual Basic editor and saved as an .xla file) so that it is
visible when I try to use the Macro manager to assign and use it as a Macro?

I created the program and it runs fine from the VBA editor--I just can't get
to it once I load it via the .xla mechanism--it doesn't show up in the
selection window.
--
Thanks,

--

Dave Peterson

--

Dave Peterson