randymadden
Board Regular
- Joined
- Apr 22, 2008
- Messages
- 62
Over the years I have developed a really nice QAT that makes my work so much faster. I know that QATs can be moved around and so I'd like to use my work QAT at home. However, I'm finding that any button attached to a macro also carries with it its path. When I go to use that button at home I get a message to the effect that the path doesn't exist.
I'm wondering if any of you amazing Mr. Excel people have a solution? I'm thinking either:
1) Strip out the path(s) somehow, or 2) use some form of find/replace to modify all paths at once.
As it stands, each time I encounter one of the dysfunctional buttons I have to re-point it at the macro on my local machine.
Any ideas?
Thanks, Rm
I'm wondering if any of you amazing Mr. Excel people have a solution? I'm thinking either:
1) Strip out the path(s) somehow, or 2) use some form of find/replace to modify all paths at once.
As it stands, each time I encounter one of the dysfunctional buttons I have to re-point it at the macro on my local machine.
Any ideas?
Thanks, Rm