Results 1 to 3 of 3

Spell Check Macro for Protected Sheet

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2020
    Location
    Owings Mills, MD
    MS-Off Ver
    1911
    Posts
    4

    Question Spell Check Macro for Protected Sheet

    Hi everyone,

    I will try to explain this as thoroughly yet as simply as possible.
    Comment Box.png

    Basically, I'm protecting the sheet with the exception of a few cells. The comment box in the image can be typed in and can have the row adjusted when the sheet is locked.


    Since protecting the sheet results in spell check being disable, I've added a macro to the sheet which will run when a specific image is clicked.

    This is an example of the macro I'm using;
    Sub SpellCheckCell1()
        With ActiveSheet
            .Unprotect ("Maryland123")
            .Range("A37:AI37").CheckSpelling
            .Range("A76:AI76").CheckSpelling
            .Range("A123:AI123").CheckSpelling
            .Protect ("Maryland123")
        End With
    End Sub

    The problem I'm facing now is when the macro automatically protects the sheet again, it's not allowing the rows to be adjusted anymore. Does anyone know how I can alter the code shown above so the macro will protect the sheet but still allow the specific cells to be adjusted?
    Last edited by Pepe Le Mokko; 01-02-2020 at 12:30 PM. Reason: +Code tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. 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
  3. [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
  4. [SOLVED] Protected sheet spell check
    By Liz in forum Excel General
    Replies: 0
    Last Post: 05-11-2006, 12:10 PM
  5. [SOLVED] Spell check in a protected sheet
    By Jae in forum Excel General
    Replies: 1
    Last Post: 04-28-2006, 03:55 PM
  6. Allow unprotected cells to spell check after sheet is protected
    By Numberonekraut (Hans) in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2005, 03:05 PM
  7. [SOLVED] protected spell check for Excel 97
    By Jessica in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2005, 03:06 PM
  8. [SOLVED] spell check in an Excel protected sheet
    By Cats in forum Excel General
    Replies: 1
    Last Post: 02-16-2005, 04:37 PM

Tags for this Thread

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