enable spell check

  • Thread starter Thread starter Nydia
  • Start date Start date
N

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?
 
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
 
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





.
Click to expand...
 
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
 
Back
Top