+ Reply to Thread
Results 1 to 2 of 2

Spell Check cells in Protected Worksheet?

  1. #1
    Jugglertwo
    Guest

    Spell Check cells in Protected Worksheet?

    Is it possible to run the spelling checker on a worksheet when the worksheet
    is protected?
    It doesn't appear that it is possible through Excel's "normal" options.
    A customer has created a protected Excel form with certain cells unlocked
    for data. If the person misspells data in these cells, the spelling checker
    is not available.
    Any way around this?
    Any suggestions would be appreciated!
    Thanks.
    Jugglertwo

  2. #2
    Gord Dibben
    Guest

    Re: Spell Check cells in Protected Worksheet?

    You can use this macro to unprotect, run the spellcheck, then re-protect the
    sheet.


    Sub Spell_Check()
    ActiveSheet.Unprotect Password:="justme"
    Cells.CheckSpelling SpellLang:=1033
    ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
    Contents:=True, Scenarios:=True
    End Sub


    Gord Dibben Excel MVP

    On Thu, 27 Jul 2006 11:17:02 -0700, Jugglertwo
    <[email protected]> wrote:

    >Is it possible to run the spelling checker on a worksheet when the worksheet
    >is protected?
    >It doesn't appear that it is possible through Excel's "normal" options.
    >A customer has created a protected Excel form with certain cells unlocked
    >for data. If the person misspells data in these cells, the spelling checker
    >is not available.
    >Any way around this?
    >Any suggestions would be appreciated!
    >Thanks.
    >Jugglertwo


    Gord Dibben MS Excel MVP

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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