Quote:
Originally Posted by omahadivision
I had to remove "ThisWorkbook." from MacroName and then it ran like a charm!
|
Whilst it might work well enough without "ThisWorkbook.", you still should reference the workbook from which the code is to be run, so you don't run into problems when multiple workbooks are open and: (a) the macro you want to run isn't in the active workbook; and/or (b) there is more than one sub of the same name in the different workbooks.