Toolbar buttons have wrong folder path for PERSONAL.xls

H

hmm

Recently, when I activate a personal macro using a toolbar button, I get the
message "A document with the name 'PERSONAL.xls' is already open." When I
examine the name of the macro assigned to the button, its path is to a
network folder (where I recently saved a backup copy of PERSONAL.xls), not
its correct location on my C: drive.

I have been changing the assigned macro to C:\...\Personal.xls, seemingly
more than once for some macro buttons.

How do I fix this problem (for good) and prevent it from happening again?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top