shanghaigerma.blogg.se - Macro for mac computers

Title Photo: Alexander Schimmeck on Unsplash Summary: You can copy macros from your Personal.xls file to other computers.

You drag modules from MyPersonal.xls to Personal.xls on the new computer. All the macros will have been copied into Personal.xls on the new computer.įigure 137.

Drag the modules from MyPersonal.xls into the Modules folder in Personal.

Expand MyPersonal.xls so you can see each individual module.

In the VBA Project Explorer, expand Personal.xls so you can see the modules entry.

This will create the Personal.xls in the proper folder. When the macro recorder starts, move to a new cell and then stop recording. If this computer does not already have a Personal.xls file in the Project Explorer, create one by choosing to record a new macro and specifying that it should be saved in Personal.

Open to VBA editor by pressing Alt+F11.

On your co-worker’s computer, follow these steps: You choose Personal.xls in the Project Explorer. E-mail MyPersonal.xls to your co-worker.įigure 136. You can use any folder you like, but make sure to save it with a name other than Personal.xls.

In the immediate window, type ThisWorkbook.SaveAs “C:\MyPersonal.

Press Ctrl+G to display the immediate window.

Click the Save icon in the toolbar to ensure that your latest changes are saved ( Figure 136).

Find Personal.xls in the Project Explorer.

Open the VBA editor by pressing Alt+F11.

Solution: Follow these steps to save your Personal.xls file: Basically, you need to save your Personal.xls file with a new name, send that file to the co-worker, and drag modules from your workbook to your co-worker’s workbook in the VBA editor. Setup: This process is not as daunting as it may seem. You would like to get them in a co-worker’s Personal Macro Workbook. Challenge: You have a bunch of cool macros in your Personal Macro Workbook.