View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default See User Form On Open

You could use a macro.

This goes in a General module--not behind a worksheet and not behind
ThisWorkbook.

Option Explicit
Sub Auto_Open()
userform1.show
End Sub

Change userform1 to the real name of your userform.

wx4usa wrote:

I have built a user form per Debras instructions @ contextures. It
works fine, but when I close and save and later re-open, how do I see
my form? Is there a way to make it automatically re-appear on
opening? Or did I lose it?


--

Dave Peterson