displaying a form while allowing sheet to be editable

i want to do the following:

• initialize a sheet by showing form1, which accepts user input for rows and cols
• name a range on the sheet of size rows x cols
• display form2 which is just a "DONE" button that they click when they're finished
• pause/stop the macros and allow the user to fill in values for that range
• start up some other macros when they press the "DONE" button

i tried it and found that when you display a form it locks the sheet (can't select the sheet to input values) and you can't even alt tab away from the form. is there a way around this?

thanks in advance for any help.

You need to show the form modelessly:

Please Login or Register  to view this content.