Thanks for the reply,
Where do I insert this command?
I inseted it in the main command button that runs my program and got an error.

Thanks

"Jim Thomlinson" wrote:

The show method has one optional argument which specifies if the form is
modal or not. Set it to false...

UserForm1.Show False

--
HTH...

Jim Thomlinson


"David" wrote:

Hello,
I created a form that has some buttons. When pressed some code excecutes
and creates an excel spreadsheet.
However I cannot access/modify the sheet unless I close the form window.
Is there any way to keep the from visible/accessible while working with the
spreadsheet?

Thanks