Excel takes forever to react again after closing userform

I have a button that closes the userform, named "Annuleren". Whenever this is clicked, the userform closes and excel kind of freezes for a time (10+ seconds).
I don't think the code is that complicated, but for some reason it causes a complete meltdown.

below the code for the sub that hides the userform, the one for Userform_Terminate is roughly the same.

Please Login or Register  to view this content.

the file contains 1 userform and 43 sheets.
I've tried keeping out .Select and/or the protection on the sheets, but it still takes forever.
The code is fairly large, but in a comparable file this works much more smoothly...
Am i missing something?

Hi Rick,

thank you for your reply. I initially tried to work with Unload me, but that also didn't help.
It was still slow. I just tried it again and no difference in time...

@ Norie, the code is above in the first post, although I use 'Unload Me' instead of of 'Hide'. Hide was a test to see if that would speed it up.

@ Arkadi, yes, it doesn't make a difference at all.

I think i found the reason why it is so slow, it's probably because it has to update roughly 220 pivot tables..
I'll try to find out if i can do it with less tables to see if that speeds things up.
I assume that will work.. Sorry for wasting your time, appreciate it a lot though!

Edit: I'll put the post on solved as soon as i tried this

it was the amount of pivot tables that slowed it down this much. Topic solved.