VBA Code much slower in one workbook compared to another

[swayp11]

I wrote a VBA macro to manipulate some data in a tab with a module in my Personal Workbook. Everything works great and fast.

Now I'd like distribute this to my team, so I do my normal steps:

1. Create a macro-enabled workbook. This is completely empty.
2. Add a module.
3. Paste the exact code from my personal workbook to the module in the macro-enabled workbook.
4. Add a button that ties to the module. Now the workbook is complete empty except for the button.
5. Paste the data into the tab with the button (the same exact data I was using when running the code from my personal workbook).
6. Click the button.

The code when clicking the button is WAY slower. Like 10x slower. What would be the cause of that? I tried moving the code to the actual sheet or thisworkbook, same result. I've added in screenupdating and calculation code, though this shouldn't matter since it's the same exact code as I was using in the personal workbook.


Any ideas?

 

[tonyyy]

Posting the code might encourage some responses...

Cheers,

tonyyy

 

[Peter_SSs]

Posting some small relevant sample dummy data to test on would also be useful.