Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Use spell check on unprotected ( unlocked) cells

3 views
Skip to first unread message

Chris

unread,
Oct 16, 2002, 10:33:57 AM10/16/02
to
Can it be done on a protected sheet and if so,how?

Chris

Dick Kusleika

unread,
Oct 16, 2002, 2:51:04 PM10/16/02
to
Chris

No. As far as I can tell, the sheet must be unprotected. You could use a
macro to unprotect the sheet and only check certain cells, then reprotect.
Here's an example.

Sub test()

Dim rng As Range
Dim cell As Range

Sheet1.Unprotect

For Each cell In Sheet1.UsedRange
If Not cell.Locked Then
If rng Is Nothing Then
Set rng = cell
Else
Set rng = Union(rng, cell)
End If
End If
Next cell

rng.Check

Sheet1.Protect

End Sub

--
Dick Kusleika
MVP - Excel

Post all replies to the newsgroup.

"Chris" <lsa...@charter.net> wrote in message
news:3fd301c27521$0f6541e0$37ef2ecf@TKMSFTNGXA13...

Dick Kusleika

unread,
Oct 16, 2002, 2:55:16 PM10/16/02
to
Sorry, this line

> rng.Check

should say

rng.CheckSpelling

--
Dick Kusleika
MVP - Excel

Post all replies to the newsgroup.

"Dick Kusleika" <di...@paragonconstructioninc.com> wrote in message
news:#MvWuSUdCHA.1540@tkmsftngp10...

0 new messages