M manoj_th Member Mar 30, 2012 #1 Hello, I have created a macro which is working perfectly, but when I am opening a new excel file unable to run the macro. Please advise me who to save that macro which should be run in any excel file even the file which has macro is closed.
Hello, I have created a macro which is working perfectly, but when I am opening a new excel file unable to run the macro. Please advise me who to save that macro which should be run in any excel file even the file which has macro is closed.
Luke M Excel Ninja Staff member Mar 30, 2012 #2 Sounds like you need to either make the macro an add-in, or save it in your Personal workbook. http://www.rondebruin.nl/personal.htm
Sounds like you need to either make the macro an add-in, or save it in your Personal workbook. http://www.rondebruin.nl/personal.htm