Personal Macro hide issue

Hi Sanjay

The Personal Macro Workbook is a special hidden workbook that is saved directly onto your computer, not attached to any particular Excel document.

This means if you have saved macros to the Personal Workbook then changed laptop, the macros from your old laptop will not be available on your new one unless you copy them over into a macro-enabled workbook.

To move macros from the Personal.xlsb workbook to a different workbook, follow these steps:

1) Make sure the workbook that is the target of your macro transfer operation is loaded.
2) Unhide the Personal.xlsb file by displaying the View tab of the ribbon and clicking Unhide within the Window group.
3) Press Alt+F11 to display the VBA editor.
4) Using the Project window, display the macros that you want to move.
5) Select (highlight) and cut (Ctrl+X) the macros from their original location in Personal.xls.
6) Using the Project window, display the module in the workbook where you want the macros to be. (If there is not an existing module in the workbook, you may need to create one.)
7) Paste (Ctrl+V) the macros in the module.
8) Close the VBA editor.
9) Hide the Personal.xlsb file by displaying the View tab of the ribbon and clicking Hide within the Window group.
10) Close and save the workbooks.

Hopefully this should solve your problem, but let me know if you have any further issues.

Regards,

Sarah
Excel Trainer