Spell check in protected cells?

[Tyler Durden]

Is there any way to run the spell check on a protected cell/sheet? I have a form that will be a mixture of text and numbers. Some of the cells will need to be spell checked but it seems that once I protect the sheet, spell-check is disabled. Any help?

Thank you in advance.

 

[lenze]

You will need to record or write a macro that unprotects the sheet , does the spellcheck, and then reprotects the sheet.

 

[Tyler Durden]

Elementary. That makes total sense.

Thank you.

 

[Tyler Durden]

When I run the macro it still asks me for my password even though I recorded it during the macro recording...is there something I need to do to embed my password into the macro?

 

[lenze]

Place this line in the macro code at the appropriate place

Worksheets("Sheet1").Unprotect("password")

Also, Worksheet("Sheet1").Protect("password")to reprotect
This message was edited by lenze on 2002-04-26 13:44
This message was edited by lenze on 2002-04-26 13:48
This message was edited by lenze on 2002-04-26 13:48

 

[nancyo]

Often when I record a macro, it does not record the actual password. I find that I have to manually add it to the code, as above.

 

[Tyler Durden]

When I type in my password for the "Protect" command, I receive an error that says:
"Compile Error: Expected: End of Statement".

Am I placing my password in the wrong spot? Here is what the code looks like:

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

?????

 

[Mark O'Brien]

I don't see where you're putting your password in that line. This line of code will protect your worksheet without using a password.

The first rule of password protection is to create a password.

If you want to add a password use something like this:<pre>
ActiveSheet.Protect Password:="FightClub", DrawingObjects:=True, Contents:=True, Scenarios:=True</pre>

_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-04-29 09:55

 

[Tyler Durden]

I didn't paste it in my posting. I had been placing it after "ActiveSheet.Protect"

 

[Tyler Durden]

It works now...Thanks Mark!