B
blaze57
I want to create macros and get them to other users in my group so they can
use them. what is the best way to do that?
use them. what is the best way to do that?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
hi,
export the macro through the vb editor to a public drive
then have your other users import the macro through the vb
editor.
to export.
open the vb editor(alt+F11). on the left side, click
your project to expand it. right click the module the
macro is in. click export. it will save as with a .bas
file extention.
To import.
open the vb editor(alt+F11). on the left side, Right click
your project. click import. brouse to find the file.
export the macro through the vb editor to a public drive
then have your other users import the macro through the vb
editor.
to export.
open the vb editor(alt+F11). on the left side, click
your project to expand it. right click the module the
macro is in. click export. it will save as with a .bas
file extention.
To import.
open the vb editor(alt+F11). on the left side, Right click
your project. click import. brouse to find the file.
B
Bob Phillips
Create an addin with the macros, and install on all machines.
--
HTH
RP
(remove nothere from the email address if mailing direct)
--
HTH
RP
(remove nothere from the email address if mailing direct)
D
Dave Peterson
I like Bob's suggestion of creating an addin, but then you have to give the
users someway of executing your macros.
John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm
If you want a toolbar, here's how I do it:
http://groups.google.co.uk/[email protected]
It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)
users someway of executing your macros.
John Walkenbach's menumaker adds menu items on the fly. It's really simple to
use. You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm
If you want a toolbar, here's how I do it:
http://groups.google.co.uk/[email protected]
It's not quite as pretty as John's, but I try to keep the number of items on a
toolbar less than a dozen or so. (I find the menus much nicer.)