View Single Post
  #1  
Old 16-08-2013, 04:47
Harry Harry is offline
Member
 
Join Date: Apr 2007
Location: London UK
Posts: 58
Default 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.
Reply With Quote