enable spell check

[Nydia]

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?

 

[Henry]

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]

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





.

 

[pfsardella]

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

 

[Henry]

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 Autpen()
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