|
Using XLA to load VBA program
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 |
Using XLA to load VBA program
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 |
Using XLA to load VBA program
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 |
| All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com