Hide ACTIVE WORKBOOK and show userform. Show ACTIVE WORKBOOK with cmdbutton.

Hi all,

I've created a Userform which I want to show as it's own stand alone application. However, when I hide Excel, it hides all other Excel workbooks as well. I only want to hide the Workbook associated with the Userform.

So far I've tried:

Thisworkbook.visible = false
userform1.show

It works, but when clicking on my commandbutton to show the workbook again, it only shows an empty Excel - no worksheet at all.

I want the workbook and worksheet to be visible when clicking the command button.

Please help! I will be forever grateful.

To show the form and hide the workbook:

Please Login or Register  to view this content.

To close the form and show the workbook again (add code to the button on the form):

Please Login or Register  to view this content.