workbook that automatically loads whenever Excel runs. Any macro in your Personal
Macro Workbook is available to all workbooks. When you store your macro in your current
workbook, it becomes available to other users of that workbook on their computers. It
is also available to other open workbooks. This is a good option if you want to share
your macro with others. When you store your macro in another workbook through the
New Workbook option, you will need to keep the new workbook open to use the macro in
your current workbook. This option is suitable when you are creating many macros for
different kinds of applications and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.