it returns a "Method or Data Member not found." on the UserForm1.Showmodal =
Fasle

"dmoney" wrote:

not .show, .showmodal

"Steven" wrote:

Yes, UserForm1.Show False

"dmoney" wrote:

Have you tried userform1.showmodal=false


"Steven" wrote:

Thank you for the response. That hides it but I want the form to show all
the time.

I tried:

UserForm1.Hide
UserForm1.Show

but this hangs up the system, which makes sense. Is there another way to
get the focus to the selected file but keep UserForm1 showing and still
available? There are many files open that can be selected. UserForm1 is a
form in one of the files (a control file.)

Thank you,

Steven

"dmoney" wrote:

userform1.hide should do it


"Steven" wrote:

I have a UserForm that has a listbox which has the names of files that are
open. When the user clicks an item in the listbox it will go to that file
with:

Workbook(wb).Activate

But the UserForm still has the focus. I have to actually click on the
workbook window to get the scroll to work. How can I get the focus to the
File window from the UserForm after the Workbook(wb).Activate command in the
UserForm without closing the UserForm or doing an Unload UserForm?

Thank you,

Steven