Testing Excel macros

Hello Lisa,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding testing a macro across different workbooks. The answer to this question will differ slightly depending on where the macro was saved...

This Workbook or Personal Macro Workbook.

In order to run a macro saved in 'This Workbook' into a different workbook, the workbook in which the macro was originally recorded must be open. That step will of course not be necessary if the macro was saved in the 'Personal Macro Workbook'.

Just a word of caution! You used the word 'testing' your macro. Please make sure that if you are running macro tests that you make backup copies of the files and run your tests on those backup files. Remember, you cannot use the undo button after running a macro.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer