Macro location

[pcor]

I have a file called PERSONAL.XLS that contains all my macros.It is located
in STRARTXLS
I had reason to copy that file and an other Excel file to drive A(Floppy)
Now every time I try to run a macro the computer looks to drive A.
How can I stop this ?
Thanks

 

[BrianB]

First off, you should never copy files from Excel to a floppy - it
gives too many problems because of the way Excel uses its temporary
file. The file can get corrupted. Save to our hard drive and copy from
there.

The change of location is "a feature not a bug" <grin>.
Your buttons or whatever you run the macros from have been
automatically pointed to the new location, and you have to re-assign
them. Another reason not to copy from Excel to somewhere else.

Regards
BrianB
================================================================