I've been sent an Excel Workbook and an add in. I'm told that when used
together, several additional menu options are available to the user.

1) Is there an obvious place where the add-in should be saved on my system?
2) How do you add menu options with an add-in
3) Apparently, the menu option is only displayed when one workbook is used.
How is this set up.

I don't need code, I just need some explanations.

Thanks,
Barb Reinhardt

Hi Barb:
Save it wherever you like (but remember where!)
Use Tools | Addin and click the Browse button ; navigate to the folder you
save XLA in; select it.
Not sure what Q3 means; maybe try opening the XLA file as if it were an XLS
file and the instructions are displayed.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Barb Reinhardt" wrote in message
...
I've been sent an Excel Workbook and an add in. I'm told that when used
together, several additional menu options are available to the user.

1) Is there an obvious place where the add-in should be saved on my
system?
2) How do you add menu options with an add-in
3) Apparently, the menu option is only displayed when one workbook is
used.
How is this set up.

I don't need code, I just need some explanations.

Thanks,
Barb Reinhardt

I would suspect there is code in the "WorkBook_Open" event module that
uses routines from the add-in to build the menu options.

On Mar 21, 9:22 am, Barb Reinhardt
wrote:

3) Apparently, the menu option is only displayed when one workbook is used.
How is this set up.

#1. If the addin has UDFs that are used in formulas on a worksheet, I'd ask the
sender where he/she stores their copy.

You may not have to worry about changing link sources if you can use the same
location (like C:\myutils\myaddin.xla).

But if there are no UDFs used, then you can store it anywhere you want. Then
use Tools|Addins to browse for it and install it.

Alternatively, you could put it in your XLStart folder, too.

#2. I like these:
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)

#3. You can use the workbook_activate and workbook_deactivate to show/hide the
menu options.

A little search of google and you'll find lots of samples.



Barb Reinhardt wrote:

I've been sent an Excel Workbook and an add in. I'm told that when used
together, several additional menu options are available to the user.

1) Is there an obvious place where the add-in should be saved on my system?
2) How do you add menu options with an add-in
3) Apparently, the menu option is only displayed when one workbook is used.
How is this set up.

I don't need code, I just need some explanations.

Thanks,
Barb Reinhardt

--

Dave Peterson