Share via

how can I create macros that everyone can use?

Anonymous
2023-07-07T21:30:23+00:00

I've created macros in my workbook and tried saving it on my personal.xlsb and "on the workbook" but when others try to use the macro they get error messages that the macro cannot be found. How can I create macros on workbooks that others can use when they open the workbook?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-07-07T21:40:07+00:00

    If the macros are for a specific workbook, create them (or copy them to) a module in that workbook. They will then be available to everyone who opens the workbook.

    If you want the macros to be available in all open workbooks, you might create an Excel Add-in and distribute that add-in to other users.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-07T21:48:54+00:00

    Thank you. I'll try both! Have a great weekend.

    0 comments