+ Reply to Thread
Results 1 to 2 of 2

Spell Check greyed out [when sheet is protected]

  1. #1
    Forum Contributor
    Join Date
    09-12-2015
    Location
    Okinawa, Japan
    MS-Off Ver
    2013
    Posts
    178

    Spell Check greyed out [when sheet is protected]

    When working on a protected sheet that has some cells locked and others unlocked. Is there a way to Spell Check text in the unlocked cells?

    Thank you.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,152

    Re: Spell Check greyed out

    Spell check is disabled on protected sheets, regardless of whether there are unlocked cells. The only way to do this is a custom VBA solution which will temporarily unprotect the sheet, do the spellcheck on unlocked cells, and re-protect the sheet.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Spell Check Macro for Protected Sheet
    By nicholasmarella in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2020, 01:34 PM
  2. how do you allow spell check in a protected sheet?
    By NinjaBear in forum Excel General
    Replies: 1
    Last Post: 12-14-2011, 08:28 AM
  3. Any way to use spell check on a protected sheet?
    By vinokirk in forum Excel General
    Replies: 0
    Last Post: 09-01-2011, 07:14 AM
  4. [SOLVED] How do I use the spell check on a protected sheet in Excel?
    By jimjam in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2006, 10:55 AM
  5. [SOLVED] Protected sheet spell check
    By Liz in forum Excel General
    Replies: 0
    Last Post: 05-11-2006, 12:10 PM
  6. Spell check in a protected sheet
    By Jae in forum Excel General
    Replies: 1
    Last Post: 04-28-2006, 03:55 PM
  7. spell check in an Excel protected sheet
    By Cats in forum Excel General
    Replies: 1
    Last Post: 02-16-2005, 04:37 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1