Userform doesn´t run while other workbook is open

[erichnagy]

Hi all.
Some backtstory first.
I made a excel userform where a (oldaged) user can filter, hide rows/columns and then "Advanced paste" to another sheet and get this printed.
I wanted to make this userform available for other workbooks but i got some error, can´t run it.

I have 1 excel workbook open to filter, and when i open my excel userform it doesn´t run, error.
I used this code in module to run the userform. I think something is missing before the Userform.show ...

Sub executeform()
Userform.Show
End Sub

Hope can i get a hand on this.
Thank you all.

 

[Logit]

The snippet of code you provided is not sufficient to make an educated correction to your code.

Post more of your code and a link to download your workbook with the code included in order to have it reviewed.

Thanks.

 

[erichnagy]

The snippet of code you provided is not sufficient to make an educated correction to your code.

Post more of your code and a link to download your workbook with the code included in order to have it reviewed.

Thanks.

Hi. There is no more code.
I have one MS excel workbook open and when i open the second MS excel and try to run the Userform.Show it gets a Error 9. But if i open the second excel alone it does run without a problem.

 

[Logit]

Can you post your two workbooks on a Cloud Download website ... for download and inspection ?

Here ... having created two workbooks and one with a user form ... I cannot reproduce the error you are seeing there.