How to Show Userform and Hide Workbook/Worksheet

I made an add in,
when I click my add in, I want to only show my user form and hide my workbook (made on user form on this workbook),
but the previous workbook or other workbook still open

I tried this code but when the user form open and all of the open workbook on excel hide as well.

Please Login or Register  to view this content.

Appreciate if you can help me..

Try:

Please Login or Register  to view this content.

Instead of the application.visible line.

Have you tried fully qualifying the workbook you would like to hide?

Ex:

Please Login or Register  to view this content.

Thanks Xero,

It works, I will try in several case if there are any error I would let you know

Please take the time to show the thread as solved.

And if you don't mind clicking the add reputation button (*) below.

It works, but before it works always show error message, still find another solution

Find the solution, this code is really works.

Please Login or Register  to view this content.

run-time error '13'
type mismatch

Originally Posted by XeRo Solus

What's the error?