LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default General question about organizing or grouping AddIns

Excel 2002
Windows XP Pro

I need help in organizing a suite of AddIn tools that I've developed in
Excel with VBA. Right now I have three AddIns that get a medium amount of
use from our office personnel. I was wondering if there are any theories or
practices for packaging them together under a single AddIn. I'm thinking
that simply putting the code in a single VBA project would require too much
re-working, especially in regards to variable declarations.

One idea I have is to use the PERSONAL.XLS file to create a standard menu in
Excel and then add a new sub menu to that menu for each AddIn that is
activated. This would keep the main menu bar from getting too cluttered but
still isn't as simple as I would like. Does anybody know of any articles or
texts that deal with this?

Any suggestions appreciated.

-gk-


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
General question Rookie User[_2_] Excel Worksheet Functions 2 February 8th 10 07:34 PM
Formula Question (Organizing Data) Telobamipada Excel Discussion (Misc queries) 3 January 4th 07 02:24 PM
General Question Me Excel Discussion (Misc queries) 3 January 12th 06 12:55 PM
Question on Addins dalkar Excel Discussion (Misc queries) 3 October 17th 05 02:50 PM
As Addins load question Stuart[_5_] Excel Programming 4 July 12th 03 09:22 PM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"