Global macros are typically stored in a file named Personal.xls.
Search for this file and copy it to your new drive.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Kelly" <Ke...@discussions.microsoft.com> wrote in message
news:4666C4F0-141D-4952...@microsoft.com...
>I just purchased a new hard drive and I need to copy my global
>macros to the
> new drive for Excel. I am still using Office 97. Can anyone
> help me on how
> to do this?