This code already works as long as I assign the macro manually each time I open the document. It resets to "filename.xlsm!Sheet1.material"-macro, but when I manually change it back to "Sheet1.material"-macro it works fine until I close/open it again.
I was wondering if anyone could tell me whats wrong and how to make this happen automatically.
Please Login or Register to view this content.
Bookmarks