MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Initial setup when recording a macro.


Posted by mike on November 19, 2001 8:55 AM

When you begin recording a macro, and you want to make
it available to anyone using the file, do you attach it to "this workbook" or "all workbooks"?

thanx,
Mike


Posted by Dank on November 19, 2001 9:08 AM

ThisWorkbook.

Regards,
Dan.

Posted by Mike on November 19, 2001 10:17 AM

Dank

* * * *

Thanks.
Where do I set it up so that I can use the same
Macro and apply it to any file I create in Excel.

Posted by Dank on November 19, 2001 4:07 PM

Re: Dank

Save it in your Personal.xls workbook. This is an option when you record a macro. You can choose Personal Macro Workbook. This only makes the macros available on your PC though.

Regards,
Daniel.