Linda- Me, too, Thanks!! Thanks again. Robert -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of ARRLIV Sent: 2006-11-30 11:14 To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Making macro available to ALL workbooks ? Thank you THANK YOU THANK YOU I have been looking for a way to do this for a long time THANK YOU Arr ----- Original Message ----- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> To: <mso@xxxxxxxxxxxxx> Sent: Thursday, November 30, 2006 8:30 AM Subject: [mso] Re: Making macro available to ALL workbooks ? 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 *************************************************************