Switching between worksheets / windows.

[HighAndWilder]

Excel is so frustrating sometimes.

What should be quite simple is often so tricky and time consuming.

I have a number of worksheets open, all but one are minimized.

These are opened from a Userform.

The one that is mazimised is the one that Userform is in.

All I want to do is switch between windows and keep the Userform on top.

Thanks

 

[6StringJazzer]

The UserForm is a child window of the workbook that owns it. If you set the ShowModal property to False, the UserForm will always be on top when you are working on the workbook that owns it. However, it will not be on top if you change focus to another workbook (or any other Windows application) that covers up the workbook that owns the UserForm.

However, you can manage it with some low-level code found in this post. It looks like you will probably have to update it for 64-bit.

 

[HighAndWilder]

Thanks 6StringJazzer

It all makes sense now.

I've adopted another approach by copying the worksheet from another workbook that I want to work on from the Userform and then
copying it back again when I am finished. It works fine.