Open new workbook from userform on top

[soood]

Hi All...

I am trying to copy a sheet from a form into a new workbook and I would like that new workbook to open on top of the originating workbook (and form)...When I run it now, it falls behind userform.

I would think this is possible, as when I open a new workbook manually (by clicking on MS excel) it opens a workbook on top...Any ideas?

Thanks!

 

[Aleng]

pls post ur code

 

[mikerickson]

Userforms always are above any worksheets. You might want to hide the userform after the new workbook is created.

 

[soood]

I know the form stay above worksheets, this is a new workbook. As I stated earlier if I open a workbook manually it will open on top of the form, I would think this could be duplicated programatically.

Private Sub CommandButton57_Click()
Sheets("managecoop").Select
    Sheets("managecoop").Copy
End Sub

Thanks!