Hi,
I hope you could help with a macro issue.
I wrote several macros in VBA that were probably assigned to a specific
file. I copied them to another file and the keyboard shortcuts do not
function properly. It seems that the name of the macro in the new file has an
addition of the file name to the macro name such as
"SAR_Data.xls!CheckBit.CheckBit"
instead of just "CheckBit".
Other macros that were copied and didn't have the file name extension were
functional with the shortcuts.
I was wondering if there is any way to change macro's property to become
file specific and when I create a copy of the macro, the keyboard shortcuts
will be operational?
I even tried to assigned a macro to custumized tool bar and assign a key to
it. But it seems that the tool bar button is attached to a specific macro and
not generalized one, so it couldn't help me in other files. I would rather
not have the macros sit in presonal.xls
If you got any solution to that problem I'll appriciate it.
thanks,