EXCEL WORKSHEET PROTECTION

[BRIAN MILLER]

Looking for help for the following: A worksheet is set up
with several "unlocked cells" and then the worksheet
protection is activated. Once the protection is activated
the spell checking tool is no longer available for the
unprotected cells. Is there a way to activate the
spellchecker for the unprotected cells.

[Dave Peterson]

Maybe you could provide a macro that would start the spell checking.

If you protect the worksheet with code, you can allow more stuff.

For instance:

Option Explicit
Sub testme()

Dim wks As Worksheet
Set wks = ActiveSheet

With wks
.Protect Password:="secret", userinterfaceonly:=True
End With

End Sub

Sub testme2()
Cells.CheckSpelling SpellLang:=1033
End Sub

Testme protected the sheet from the user (for a lot of things). But it allows
the second macro to run.

This option (userinterfaceonly) is not remembered by excel. You'll have to
reapply it when you open the workbook (auto_open/Workbook_Open code).

The bad news is that once the spellcheck dialog is opened, the user can press
the change all and change spelling in cells that are locked.

--

Dave Peterson
ec3...@msn.com