show userform

[john tempest]

i have a userform which at the moment i open up with a command button. i want
it to open as soon as i open the workbook. ih ave tried the following:
Private Sub Workbook_Open()
Sheet1.Unprotect Password:="troytempest1"
UserForm1.Open
Sheet1.Protect Password:="troytempest1"
End Sub

i have tried it with and without the protect and unprotect. i have also
tried several other ways. i am missing something really simple,can anyone see
what i am doing wrong
thankyou John

[aidan.heritage@virgin.net]

It needs to be actually on the OPEN event of the workbook, and I think
that it should be userform1.show

[Bob Phillips]

IT is Userform1.Show not open, and that code should be in the ThisWorkbook
code module.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"john tempest" <johntempest@discussions.microsoft.com> wrote in message
news:EB3B5771-E995-4699-8A29-946C5E0E9443@microsoft.com...
> i have a userform which at the moment i open up with a command button. i
want
> it to open as soon as i open the workbook. ih ave tried the following:
> Private Sub Workbook_Open()
> Sheet1.Unprotect Password:="troytempest1"
> UserForm1.Open
> Sheet1.Protect Password:="troytempest1"
> End Sub
>
> i have tried it with and without the protect and unprotect. i have also
> tried several other ways. i am missing something really simple,can anyone
see
> what i am doing wrong
> thankyou John

[john tempest]

"aidan.heritage@virgin.net" wrote:

> It needs to be actually on the OPEN event of the workbook, and I think
> that it should be userform1.show
> tried userform1.show
that does not work either. i am missing something but i dont know wht it is
>

[john tempest]

thankyou bob i'd put it in the wrong place
regards john

"john tempest" wrote:

>
>
> "aidan.heritage@virgin.net" wrote:
>
> > It needs to be actually on the OPEN event of the workbook, and I think
> > that it should be userform1.show
> > tried userform1.show
> that does not work either. i am missing something but i dont know wht it is
> >

[Bob Phillips]

My pleasure.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"john tempest" <johntempest@discussions.microsoft.com> wrote in message
news:8FA3F098-E1B8-45AB-B9BE-9441B990EECB@microsoft.com...
> thankyou bob i'd put it in the wrong place
> regards john
>
> "john tempest" wrote:
>
> >
> >
> > "aidan.heritage@virgin.net" wrote:
> >
> > > It needs to be actually on the OPEN event of the workbook, and I think
> > > that it should be userform1.show
> > > tried userform1.show
> > that does not work either. i am missing something but i dont know wht it
is
> > >