I wrote a macro that will recognize eight different filenames and run
the appropriate section of code when one of those eight (Excel) files
are open. My goal is to make this macro available to a few other
users by creating a .xla file and saving it on a folder on a network
drive. I've created this add-in and placed it in the desired folder
on the network drive and I've looked over this Google group and other,
similar groups but still can't put all the pieces together to make
this available to others. I initially thought this would (should?) be
easy to do but apparently it's not. Any/all suggestions would be
appreciated.
Thanks,
Sheldon Potolsky

Why you want to store this code in an add in instead of a Workbook?

Here's hoow to make the add-in available to other users. Have them go to
Tools menu > Add-Ins, click Browse, then find the add-in on the network.
Once selected, it will be checked in the list, and when you click okay it
will be installed. Any toolbars or other UI elements that it builds will be
available so the user can actually use the code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sheldon Potolsky" <(E-Mail Removed)> wrote in message
news:73e94ed9-6c89-4679-b281-(E-Mail Removed)...
>I wrote a macro that will recognize eight different filenames and run
> the appropriate section of code when one of those eight (Excel) files
> are open. My goal is to make this macro available to a few other
> users by creating a .xla file and saving it on a folder on a network
> drive. I've created this add-in and placed it in the desired folder
> on the network drive and I've looked over this Google group and other,
> similar groups but still can't put all the pieces together to make
> this available to others. I initially thought this would (should?) be
> easy to do but apparently it's not. Any/all suggestions would be
> appreciated.
> Thanks,
> Sheldon Potolsky

One problem. After creating the add-in, I tried to create a button
and assign a macro (Macros/Custom Button/Modify Selection/Assign Macro
but "Macros In" had no visibility to where I placed my .xla (add-in).
It would only allow me to look in All Open Workbooks, This Workbook or
PERSONAL.XLS. I thought I'd try to manually create a button and see
if it worked but can't figure out how to make it point to where I'd
like it.
Thanks,
Sheldon

On Mar 17, 10:20*pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> Here's hoow to make the add-in available to other users. Have them go to
> Tools menu > Add-Ins, click Browse, then find the add-in on the network.
> Once selected, it will be checked in the list, and when you click okay it
> will be installed. Any toolbars or other UI elements that it builds will be
> available so the user can actually use the code.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> "Sheldon Potolsky" <SHPsalm...@aol.com> wrote in message
>
> news:73e94ed9-6c89-4679-b281-(E-Mail Removed)...
>
>
>
> >I wrote a macro that will recognize eight different filenames and run
> > the appropriate section of code when one of those eight (Excel) files
> > are open. *My goal is to make this macro available to a few other
> > users by creating a .xla file and saving it on a folder on a network
> > drive. *I've created this add-in and placed it in the desired folder
> > on the network drive and I've looked over this Google group and other,
> > similar groups but still can't put all the pieces together to make
> > this available to others. *I initially thought this would (should?) be
> > easy to do but apparently it's not. *Any/all suggestions would be
> > appreciated.
> > Thanks,
> > Sheldon Potolsky- Hide quoted text -
>
> - Hide quoted text -

I'm not sure what the best way to accomplish this but my goal is still
to make an Excel VBA module that I wrote and is in my PERSONAL.XLS,
available to a few other users. I'm open to the easiest/best way to
do this.
Thanks, Sheldon

On Mar 17, 9:50*pm, "gimme_this_gimme_t...@yahoo.com"
<gimme_this_gimme_t...@yahoo.com> wrote:
> Why you want to store this code in an add in instead of a Workbook?

Don't try to build the toolbar manually. It will not work properly.

Here are some links that show how to build a toolbar or menu automatically
when a workbook is opened:

http://contextures.com/xlToolbar02.html
http://www.j-walk.com/ss/excel/tips/tip53.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sheldon Potolsky" <(E-Mail Removed)> wrote in message
news:6159d252-e27d-42c9-84e8-(E-Mail Removed)...
One problem. After creating the add-in, I tried to create a button
and assign a macro (Macros/Custom Button/Modify Selection/Assign Macro
but "Macros In" had no visibility to where I placed my .xla (add-in).
It would only allow me to look in All Open Workbooks, This Workbook or
PERSONAL.XLS. I thought I'd try to manually create a button and see
if it worked but can't figure out how to make it point to where I'd
like it.
Thanks,
Sheldon

On Mar 17, 10:20 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com>
wrote:
> Here's hoow to make the add-in available to other users. Have them go to
> Tools menu > Add-Ins, click Browse, then find the add-in on the network.
> Once selected, it will be checked in the list, and when you click okay it
> will be installed. Any toolbars or other UI elements that it builds will
> be
> available so the user can actually use the code.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. -http://PeltierTech.com
> _______
>
> "Sheldon Potolsky" <SHPsalm...@aol.com> wrote in message
>
> news:73e94ed9-6c89-4679-b281-(E-Mail Removed)...
>
>
>
> >I wrote a macro that will recognize eight different filenames and run
> > the appropriate section of code when one of those eight (Excel) files
> > are open. My goal is to make this macro available to a few other
> > users by creating a .xla file and saving it on a folder on a network
> > drive. I've created this add-in and placed it in the desired folder
> > on the network drive and I've looked over this Google group and other,
> > similar groups but still can't put all the pieces together to make
> > this available to others. I initially thought this would (should?) be
> > easy to do but apparently it's not. Any/all suggestions would be
> > appreciated.
> > Thanks,
> > Sheldon Potolsky- Hide quoted text -
>
> - Hide quoted text -