Userform always on top

[Scoobster_doo]

HI Guys,

I want my userform to always stay on top. At the moment it does until a new excel book opens up effectively hiding it.

My code in the userform is:

Please Login or Register  to view this content.

This is the code I run in my subs to call the form

Please Login or Register  to view this content.

If I run the userform code by itself, it stays on top when I click around....

any ideas?

Thanks

[Arkadi]

I found this a while back and saved it... can't take credit for it.

Please Login or Register  to view this content.

Now I look carefully you are using a version of this already, so it may not help...

[cytop]

Guess you've upgraded to 2013 or 2016 rather than the 2010 mentioned in your profile...?

EDIT: The post above (and your original code) has the disadvantage that the userform will be shown over other messages, like error messages... and, if big enough, will completely hide them.

[Scoobster_doo]

I have indeed Cytop Eagle eyed! Changed it
I understand it may cover errors etc however the only error that could occur during the time of it being open/closed would be a filepath call issue really. So I'm good with that

Arkadi - I shall give it a go - thanks for trying either way!

[Scoobster_doo]

Arkadi - Sadly when opening a new excel book it still doesn't show on top
Might have to be a reactivate the userform job!

Thanks anyway

[Arkadi]

Ok here's another try... (testing on my end works with this method)

At the top of your userform code:

Please Login or Register  to view this content.

And add this to the userform_initialize code (or put all the code together in a module, put the below code in a sub, and call it from the userform initialize):

Please Login or Register  to view this content.

[cytop]

See this recent thread...

@Arkadi: If your profile is correct (XL2010), it will work - see post #2 in the link for an explanation.

[Arkadi]

@ cytop, thanks, didn't realize this won't work in later versions. My first code post (#2) would not keep the userform on top of another instance of excel, while my last post (#6) DID stay above all other applications... I was hoping maybe that latest post would work in later versions too... but perhaps not.

Just tested in a 2013 version of office, and my post #6 does seem to keep the userform above any other application windows without problem.

[cytop]

does seem to keep the userform above any other application

Yes, it will as you're setting it TOPMOST (above all other Windows) - but that's introduces other issues especially the fact an error message or a notification from another application, can be hidden - as the OP mentioned, it's probably not a problem here, but I would pick that up in any code review and send it back for re-work. That's just me, though.

Apols in a way - I didn't mean to imply it would not work in other versions - my error by omission, I didn't make myself clear.

[Arkadi]

No worries at all cytop , I appreciate the feedback, and see no need at all for you to apologize! .... I do understand there are drawbacks, perhaps I too ought to have put a warning along with the code. I took the OP's requirement to be what that code does, but it is important to understand the consequences