How to set up a personal macro in Excel 2010

In Excel 2010 if you need to use the same macro everyday you don't want to have to recreate it each time you want to use it. You need to create a macro in your personal workbook that will be available for use from that point forward.



You need to record a dummy macro and save it to your personal file.

Once saved you need to unhide the workbook.

Once unhidden you can edit the macro and then save it. Now when you click view / macro /view macro from the toolbar you will always see your personal macro.