When you set up the macro(s) in the first place:-

Store macro in: Personal Macro Workbook

If my comment has helped please hit Yes.

"robin" wrote:

Is there a way to format Excel so that a macro will work in all workbooks?