Moving macros to module 2 worked. I had 42 workbooks where I imported the code as module 2. Thanks for the suggestion.