Automatically hide the current workbook view for userform

[chunkyp]

I am facing a problem when I open my userform. What happens is that when I open my userform all the other workbooks disappear. Is there a way where only the current workbook for the userform disappears while all others remain?

Please Login or Register  to view this content.

When I run Auto_Open() I get an error for

Please Login or Register  to view this content.

stating Method or data member not found..

All the above code is added in the module1.

[cytop]

all the other workbooks disappear.

That's exactly what

Please Login or Register  to view this content.

does. You're hiding the Excel application.

Perhaps

Please Login or Register  to view this content.

might be a better alternative.

[chunkyp]

Thank you for your reply. It worked perfect.

I would also like to know what does this code mean? And why do I get an error in this instance?

Please Login or Register  to view this content.

.

Also I am using this code to close the workbook when the user form is closed without saving.

Please Login or Register  to view this content.

But now everytime I reopen I get the message stating abc.xlsm is already open. Reopening will cause any changes that you made to be discarded. Do you want to reopen abc.xlsm?

[cytop]

Your thread title is "Automatically hide the current workbook view for userform"

If that has been dealt with than all good but please keep the thread relevant to the title and start new threads for other queries.