Is there a way to create one macro and automatically copy this macro to
other workbooks? I can't use the personal.xls file, because the
workbooks will be used by multiple users. I'm also using a mac.

Thanks!