Hello all, I made a macro and added a shortcut to it on my quick access toolbar. Every time I execute the macro though (in a new workbook), it opens the original workbook/file that I saved the macro in. Is there a way to prevent this?
Hello all, I made a macro and added a shortcut to it on my quick access toolbar. Every time I execute the macro though (in a new workbook), it opens the original workbook/file that I saved the macro in. Is there a way to prevent this?
Maybe you should save the macro in your personal.xlsb file rather than within some other file. The personal.xlsb is designed to be opened "invisbible".
You might want to follow Rons instruction:
http://www.rondebruin.nl/win/personal.htm
Theo
Remember To Do the Following....
1. Upload sample files
2. Thank those who have helped you by clicking the Star below the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Thanks for the adivce, will try it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks