+ Reply to Thread
Results 1 to 2 of 2

Seeing Protected Cells

  1. #1
    Dave
    Guest

    Seeing Protected Cells

    Is there a way to see which cells are protected without having to open
    "Format/Cells.../Protect"?
    --
    Thanks
    Dave

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening Dave

    This routine will work, but only on a range, so select the range you want to check and run the macro. All cells are protected in a new spreadsheet by default, so this routine will select all the UNPROTECTED cells.

    Sub UnlockCell()
    Count = 0
    On Error Resume Next
    For Each Rng In Selection
    If Rng.Locked = False Then
    Count = Count + 1
    If Count = 1 Then Set Unlocked = Rng
    If Count <> 1 Then Set Unlocked = Union(Unlocked, Rng)
    End If
    Next Rng
    Unlocked.Select
    End Sub

    HTH

    DominicB

+ 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