Showing and hiding a user form
I have a form, which I can show and hide using userform1.show and userform1.hide.
The problem is that userform1.show causes the user form to take focus -- so that, for example, I can no longer alt-tab between open document windows or use any keyboard shortcuts.
I thought I could do this by userform1.visible = true but this gives a runtime error "function or interface marked as restricted".
So, any suggestions for displaying a form without it taking focus -- or of making it hand focus back to the document immediately afterwards.
|