Personal Macro

Hi Tracy

Here are some instructions for sharing your Personal Macro with everyone in your team. hope not too lengthy...

1. Open your VB Editor by pressing Alt F11.
2. Locate the VBA Project (Personal.XLSB) and the module containing your macro. It might be called Module1. Double click to check it contains the macro to share.
3. Rename the module from Module1 to something else eg MacroTraining. (No spaces)
4. Right click this module and select Export File.
5.If possible select a folder that your team all have access to and press Save. This creates a text file with a .bas extension.

Now each person will need to import your file into their Personal Macro folder. As some people may not have a Personal Macro file ask them to do the following:
1,. Record a macro called Macro1 and choose Personal Macro Workbook from 'Store macro in' then click ok t ostart recording.
2. Stop the recorder (small blue button).
3. Press Alt F11 to access the VB Editor.
4. First timers may need to select View, Project Explorer.
5. Select the VBA Project (Personal.XLSB) as before.
6. Right click and choose Import File and locate your MacroTraining file. Choose Open.

Your Personal Macro will then be available for that person.

Finally when exiting Excel there will be a message to save the Personal Macro Book. Say Yes to this message.

Hope you follow this ok. If not then send an email to Doug at info@stl-training.co.uk with your telephone number and I will be happy to speak with you this afternoon.

Good luck with the training tomorrow Tracy!
Doug Dunn
Best STL