enable spell check

Excel Programming >> enable spell check I created a form using excel and protected it so user's
can only input data were needed, but because i protected
the sheet, spell check doesnt work.

how can i enable spell check on a protected excel sheet?

Excel185

Excel Programming >> enable spell check Nydia,

What you need is a Userform.
You can do any sort of input validation there and you can prevent the user
changing any other cells.

HTH
Henry

"Nydia" <EMail@HideDomain.com> wrote in message
news:0a0f01c3999a$385df1c0$EMail@HideDomain.com...
> I created a form using excel and protected it so user's
> can only input data were needed, but because i protected
> the sheet, spell check doesnt work.
>
> how can i enable spell check on a protected excel sheet?

Excel Programming >> enable spell check How do I create a userform, is that in excel?
>-----Original Message-----
>Nydia,
>
>What you need is a Userform.
>You can do any sort of input validation there and you can
prevent the user
>changing any other cells.
>
>HTH
>Henry
>
>
>"Nydia" <EMail@HideDomain.com> wrote in
message
>news:0a0f01c3999a$385df1c0$EMail@HideDomain.com...
>> I created a form using excel and protected it so user's
>> can only input data were needed, but because i protected
>> the sheet, spell check doesnt work.
>>
>> how can i enable spell check on a protected excel sheet?
>
>
>.
>

Excel Programming >> enable spell check There was a discussion recently on this topic. This thread provides
some solutions.

http://www.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&safe=off&th=8a1f8ea53cd86709&rnum=1

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
>I created a form using excel and protected it so user's
>can only input data were needed, but because i protected
>the sheet, spell check doesnt work.
>
>how can i enable spell check on a protected excel sheet?

Excel Programming >> enable spell check Nydia,

From Excel, go Tools>Macro>Visual Basic Editor or press ALT + F11.

In the VBE go Insert>userform
From the toolbox, you can add controls (Labels, TextBoxes, ComboBoxes,
Command Buttons, etc.)
You can change the properties (size, colour, font, etc.) of the Userform and
controls
Double click any of the controls or on the form to add code to the controls
or form.

Go Insert>Module

In the code pane that appears, copy and paste the following

Public Sub Auto_Open()
Userform1.Show
End Sub

Save and exit.

Restart your workbook and the form should appear.
If it doesn't, go Tools> Macro>Security and check the medium box.
Save and exit and try again. Be sure to click on Enable Macros.

HTH
Henry

"Nydia" <EMail@HideDomain.com> wrote in message
news:0a4301c39a29$3b70ca10$EMail@HideDomain.com...
> How do I create a userform, is that in excel?
> >-----Original Message-----
> >Nydia,
> >
> >What you need is a Userform.
> >You can do any sort of input validation there and you can
> prevent the user
> >changing any other cells.
> >
> >HTH
> >Henry
> >
> >
> >"Nydia" <EMail@HideDomain.com> wrote in
> message
> >news:0a0f01c3999a$385df1c0$EMail@HideDomain.com...
> >> I created a form using excel and protected it so user's
> >> can only input data were needed, but because i protected
> >> the sheet, spell check doesnt work.
> >>
> >> how can i enable spell check on a protected excel sheet?
> >
> >
> >.
> >