Personal Workbook

[Dazzawm]

How do I save my personal workbook for the following reasons:-

1) If my computer crashes and needs to be wiped for whatever reason, I would like all my macros on my back up drive.

2) I have about a dozen macros on my work PC that I want to put into my personal workbook on my laptop, for whenever I work from home.

Thanks.

 

[VoG]

1. This explains where to find it http://www.rondebruin.nl/personal.htm

2. You should be able to copy code from one personal.xls, paste into NotePad (or whatever), save on a USB drive then on your laptop copy the code and paste it into personal.xls.

 

[Dazzawm]

So I need to copy them all one by one rather than copying the personal workbook and pasting that onto the other PC.

 

[mikerickson]

Alternatly, one could unhide the Personal Macro Workbook, SaveAs "BackupPMW.xlsm" and re-hide it.

 

[VoG]

So I need to copy them all one by one rather than copying the personal workbook and pasting that onto the other PC.

You can copy the lot from one personal.xls and paste into another personal.xls. If you copy the whole file and paste it you'll overwrite the original on the lappy.

 

[Dazzawm]

How do I unhide it please?

 

[Dazzawm]

You can copy the lot from one personal.xls and paste into another personal.xls. If you copy the whole file and paste it you'll overwrite the original on the lappy.

Thats ok I have none on there at the moment

 

[T. Valko]

So I need to copy them all one by one rather than copying the personal workbook and pasting that onto the other PC.

No, you can create a copy like mikerickson noted.

Although, I would give it a different name like Copy of Personal.xls.

 

[VoG]

You shouldn't need to. With Excel open, in the VBE you should see personal.xls in the Project window.

 

[mikerickson]

The Personal Macro Workbook is a hidden workbook, just like other hidden workbooks.
How to access Hide/Unhide workbooks varies from version to version. Entering "hide workbook" into Help will guide you for your version.

If all you have in the PMW is VBA code (no data stashed on the worksheets), you could export the code module from the PMW on one machine and import it to another machine's PMW.