Why doesn't spell check work on a protected worksheet?
 

Not sure as to the why of it. Here's a previous thread with a possible
workaround:

http://www.microsoft.com/office/comm...d-8da1cfc73830

tj

"Creating Order Forms is Fun" wrote:

Thank you

"tjtjjtjt" wrote:

Not sure as to the why of it. Here's a previous thread with a possible
workaround:

http://www.microsoft.com/office/comm...d-8da1cfc73830

tj

"Creating Order Forms is Fun" wrote:

I'm assuming because the spell Checker has a function to change the value-which would go
against the concept of a protected sheet(?).
Just a guess.
--
Regards;
Rob
------------------------------------------------------------------------
"Creating Order Forms is Fun" <Creating Order Forms is
wrote in message ...

it should be able to spell check fields that aren't protected

"RWN" wrote:

I'm assuming because the spell Checker has a function to change the value-which would go
against the concept of a protected sheet(?).
Just a guess.
--
Regards;
Rob
------------------------------------------------------------------------
"Creating Order Forms is Fun" <Creating Order Forms is
wrote in message ...

T

Spell check of "should" comes up with "it would be nice".

http://register.microsoft.com/mswish/suggestion.asp


Gord Dibben Excel MVP

On Wed, 22 Dec 2004 06:23:06 -0800, "T" wrote:

it should be able to spell check fields that aren't protected

"RWN" wrote:

I'm assuming because the spell Checker has a function to change the value-which would go
against the concept of a protected sheet(?).
Just a guess.
--
Regards;
Rob
------------------------------------------------------------------------
"Creating Order Forms is Fun" <Creating Order Forms is
wrote in message ...

Gord Dibben wrote...
Spell check of "should" comes up with "it would be nice".

http://register.microsoft.com/mswish/suggestion.asp
....

FWIW, Lotus 123 Release 5 (released in 1994, over a decade ago)
included a spell check tool that worked in protected worksheets. It
checked both protected and unprotected cells, though misspellings could
only be corrected in unprotected cells. FWIW, OpenOffice Calc also
provides spell check in protected worksheets.

Excel also disables Edit Replace in protected worksheets (while 123
provides this functionality, as does Gnumeric 1.4; while OpenOffice
Calc disables replace even in unprotected cells in protected
worksheets, it does display words not in its dictionary with wavy
underlines just at it does in its word processor - if only Office
provided similarly intelligent integration between Word and Excel).

Sure looks like Microsoft slapped these features into Excel so they
could put them on the spec sheets but didn't expend much programmer
time tying up all the lose ends. Such a shock if so!

Either Office is a single integrated package, in which case useful
features in one 'tool' in the package should be available to the other
tools in the package (e.g., underlining words not in the dictionary,
providing Word's Find and Replace extended wildcards to Excel Find and
Replace), or Office is just a collection of stand-alone applications,
in which case Excel hasn't had a true major upgrade since Excel 2000
(only XML functionality would support a legitimate claim to major
version upgrade, but that's problematic since it isn't available except
in the high-end Office packages).