Personal.xlsb blocking userform on workbook_open

Hi everyone,

I have a personal.xlsb file that opens whenever I open an excel file. It has some macros stored but nothing related to this case I will explain.

On my "main" file, I have a workbook_open that calls a user form.

Ever since I have the personal.xlsb, that user form does not show when I open the file like it used to do.

The userform works if I run it from inside the VBA window.

What do I need to change?

Here's the code to call the userform and the userform code itself:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you.

@AlphaFrog

Thanks for the advice, but didn't change anything.

@Stormin

Funny thing. It worked the first time, but when I tried to do one the changes at the time to test which made the difference, none work, and when I made both changes again, it no longer worked.

I will try to produce a sample file when I can (from the main file), but it's kinda hard because except for that savings sheet, there is nothing else that makes the userform show.

(I added a button to call the userform in the meantime, at least like that it works)

Thank you both for your replies.

Here's the promised template

It's alright.

For some reason, the first time I open excel it works fine, it's just on the after. Maybe it's a different issue.

Thank you for your help anyway.

I'm gonna consider it solved.