Actually, in thinking about it, you only need to put the test in the macro
for the first workbook you created the shortcut in.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
You might be able to put a If..Then check as the first line of each macro
that checks if the ThisWorkbook object's Name property is the name of the
workbook the macro was designed to work with and, if not, call the other
macro from within the current macro.... I think that should work.

--
Rick (MVP - Excel)


"Jan Kronsell" wrote in message
...
I get that. And I think I wll end up with that. The problem is, that the
users dont know anything about add-ins. And there will be produced new
macros from time to time, meaning that they have to install new add-ins
from
time to time. I "fear" that i will have to teach them how to install and
how
to use them every time. And I)m not sure how to make buttonss in the
toolbar, that intuitively tells the user, which botton to use in which
workbook?

Jan