CLose a form without exiting the workbook

[abenjamin]

HI Created an Excel form using VBA code to launch the form in full screen when the file is opened. Now I cannot get to the workbook behind the form, When I close the form it closes the workbook.
I tried Alt+F4 it close the workbook as well.

 

[rollis13]

Open your file in Safe Mode, that is, launch the file keeping the Ctrl key down; it will then start without the AutoOpen.

 

[Joe4]

Welcome to the Board!

This link shows you the VBA code you need to use to close a UserForm and not the whole workbook:

VBA Open or Close UserForm - Automate Excel

In this ArticleOpen a Userform using VBAClose a Userform using VBAInitialize a Userform in VBA In this tutorial, you will learn how to initialize, open, and close a Userform using VBA. For this example, we created a simple Userform called basicUserform shown below with a label, a textbox, and...

www.automateexcel.com