How/where can I save a vb macro that activates a pop-up dialog box so all
users can run it from their desktops.

I will add a menuitem to each desktop to run the macro but since it will
need to be updated monthy the target files will change.

Since we all share the same server, is there a way I can save this macro so
all can run it ?

Maybe you can put your code in a different workbook than the workbook with the
data, then save that code workbook as an addin (*.xla).

Then put that file in the same drive/folder/location as the workbooks that
contain the data. Then you can tell the users to open the addin before they
open their data file.

If you're making changes to the code, remember to tell them to always use the
addin located in that common location. You don't want someone saving their own
copy and using that for the next 2 years!

You'll want to give the users a way to access the macros.

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)

ORLANDO V wrote:

How/where can I save a vb macro that activates a pop-up dialog box so all
users can run it from their desktops.

I will add a menuitem to each desktop to run the macro but since it will
need to be updated monthy the target files will change.

Since we all share the same server, is there a way I can save this macro so
all can run it ?

--

Dave Peterson

Thank you! I will try that.



"ORLANDO V" wrote:

How/where can I save a vb macro that activates a pop-up dialog box so all
users can run it from their desktops.

I will add a menuitem to each desktop to run the macro but since it will
need to be updated monthy the target files will change.

Since we all share the same server, is there a way I can save this macro so
all can run it ?