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?

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" wrote in message
...
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?

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" wrote in
message
...
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?


.

Nydia,

From Excel, go ToolsMacroVisual Basic Editor or press ALT + F11.

In the VBE go Insertuserform
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 InsertModule

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 MacroSecurity and check the medium box.
Save and exit and try again. Be sure to click on Enable Macros.

HTH
Henry

"Nydia" wrote in message
...
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" wrote in
message
...
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?


.

There was a discussion recently on this topic. This thread provides
some solutions.

http://www.google.com/groups?hl=en&l...cd86709&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?