add in questions

[keithb]

I have a workbook that contains code in the sheet1 module. I understand that
if I rename it with a ".xla" extension, Excel will treat it as an add in.
Where do I need to store the .xla file? How do I indicate that a workbook
should use the add in?

Thanks,

Keith
..

[bigwheel]

You've probably got an AddIns folder somewhere on your PC not that it matters
too much because you can browse to whereever it's stored. Click
Tools>Add-Ins then the Browse button and change to the required folder

"keithb" wrote:

> I have a workbook that contains code in the sheet1 module. I understand that
> if I rename it with a ".xla" extension, Excel will treat it as an add in.
> Where do I need to store the .xla file? How do I indicate that a workbook
> should use the add in?
>
> Thanks,
>
> Keith
> ..
>
>
>