[mso] Re: Macros in Excel - Moving

Christine raises an interesting issue, and you'll hear many, many
opinions on how you really ought to do it, but little common sense. 

The only question you need to ask is, "Do I want non-expert users to be
able to use my code?"

If the answer is no, then do what I do: go into the VBE (Alt+F11), cut
and paste the code into an email or a Word doc, mail it to yourself or
other expert users and you/they can paste it into another personal
workbook or some other file whenever you need to. Copying a whole
personal workbook is dangerous, because it will overwrite the existing
one, and you might have stuff in there you'd want to keep.

If you want non-experts to use the code, then convert it into an add-in.
There's help on how to do this around the web, but there are some
gotchas you'll have to understand about making the macros available to
the user, and this will usually involve writing some extra code, maybe
adding a custom menu or toolbar from code. If you're confident doing
that, fine. If you'd like some code to get you started, feel free to
download my free Excel add-in from the link below. The code isn't
protected, so you can see how I've created the toolbar and how the code
references are kept current no matter where the file runs from.

http://www.grbps.com/adddin.htm

Good luck!

Ray

------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
www.grbps.com
------------------------------------


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of McDonald, Christine, Ms, DCAA
Sent: 30 April 2004 21:54
To: mso@xxxxxxxxxxxxx
Subject: [mso] Macros in Excel - Moving


Hi all,
I've been working on a complicated macro and it is save in my
personal.xls workbook. I would like to take it home this weekend to work
on it.  If I copy my personal.xls workbook and load it on my PC at home,
will it  move the macro(s) with it?  If not, how do I get the macro on
another PC? 

Which I guess brings up the question, if I want to share the macro with
someone after it's done, how do I give it to them?

Thanks,

Christine McDonald
Technical Specialist
Western Regional Office
Information Technology Division (RSA-4)


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: