[mso] Re: Making macro available to ALL workbooks ?

  • From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Thu, 30 Nov 2006 09:30:12 -0500

Read this:

http://personal-computer-tutor.com/personalxls.htm 


Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Thursday, November 30, 2006 3:25 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Making macro available to ALL workbooks ?

I wrote my first macro, well, really I just copied one and changed parts of
it to do what I wanted. It takes a DD formatted latitude and changes it to
its DDMMSS.xxxxx equivalent.

However, it seems to be available in just one workbook. Does this mean I
have to write it for each and every workbook? I would very much appreciate
it being available to all workbooks please.

Thank you.

Robert


*************************************************************
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, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: