how can I put the macro I need to run as the 'default'

[lablover1]

I am creating a macro for someone else to use on their workstation. How can I transfer the macro and how can I make it into the 'default'? I hope I am making sense. Thanks!

 

[Wookiee]

Disclaimer: These instructions pertain specifically to Excel 2007.

If I were to do that, I would copy the macro code into a text file and email it to the recipient. I would then pay a visit to their workstation and ask them to open their email and an Excel session. Next, I'd begin to record a macro then immediately cancel the macro recording. Then I would enter the VBA editor and paste the code into their personal macro workbook. Finally, if they wanted quick access to that macro, I would click the Quick Access toolbar and choose Quick Access Toolbar. Choose More Commands, then Choose commands from: Macros. Find the macro, click the Add button and click OK to close the toolbar customization dialogue.

I hope that helps.

 

[lablover1]

Thank you! So, these instructions will not work in 2010?

 

[Michael M]

Yep, they will.
The instructions would only be different if you were using 2003 or earlier.
'bout the only thing I'd add would be when recording the macro, type something simple in a cell, like "Hello", so the macro has content and then copy the text file over the "hello" line

 

[lablover1]

Again, thank you! Great forum.

 

[Wookiee]

Thank you! So, these instructions will not work in 2010?

Sorry for being unclear on that. It was a Friday afternoon and I had like 10 minutes before I left the office. I knew that the steps would basically work in 2010, but I wasn't sure if the references to the QAT might be different under the 2010 interface. Thanks to Michael M for clarifying.