Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Creating Order Forms is Fun
 
Posts: n/a
Default Why doesn't spell check work on a protected worksheet?


  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

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:


  #3   Report Post  
Creating Order Forms is Fun
 
Posts: n/a
Default

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:


  #4   Report Post  
RWN
 
Posts: n/a
Default

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



  #5   Report Post  
T
 
Posts: n/a
Default

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






  #6   Report Post  
Gord Dibben
 
Posts: n/a
Default

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





  #7   Report Post  
 
Posts: n/a
Default

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).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to enable font color on protected worksheet? dlterry Excel Discussion (Misc queries) 3 January 28th 05 11:19 PM
Syntax to check protected status of a worksheet? [email protected] Excel Discussion (Misc queries) 2 January 18th 05 02:53 PM
spell check protected document Sportingspaniel Excel Discussion (Misc queries) 1 January 10th 05 11:40 AM
Linking items GREATER THAN O on another worksheet in the same Work Eddie Shapiro Excel Discussion (Misc queries) 4 December 1st 04 02:55 PM
How use group and ungroup functions while worksheet is protected Gabriel De la Garza Excel Worksheet Functions 1 November 17th 04 01:44 AM


All times are GMT +1. The time now is 11:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"