Two marcos, same shortcut
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
|