View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
 
Posts: 122
Default See User Form On Open

On Oct 22, 10:22*am, Dave Peterson wrote:
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


Thanks Dave and Sheeloo !!