Results 1 to 12 of 12

Clear the contents of Unprotected cells - EXCEPT a certain range

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2015
    Location
    Charleston
    MS-Off Ver
    2013
    Posts
    10

    Exclamation Clear the contents of Unprotected cells - EXCEPT a certain range

    Hi guys,

    I'm looking to create a Macro I can assign to button that will clear the contents of all Unprotected cells in my sheet EXCEPT a specific range of cells (that are also unprotected).

    The worksheet is filled out daily, so most of it needs to be cleared and re-entered. However there are a few blocks of cells that change so infrequently that the it isn't efficient for the end user to have to re-enter daily, but they still need access to change them when necessary.

    I am using the below code which takes care of the clearing all the unprotected cells. I'm hoping there is an amendment that can be made for it to EXCLUDE the block of cells I'm referring to.

    Sub ClearUnlockedCells()
      Application.FindFormat.Clear
      Application.FindFormat.Locked = False
      Cells.Replace "*", "", SearchFormat:=True
      Application.FindFormat.Clear
    End Sub

    Thanks!
    Last edited by Leith Ross; 11-06-2015 at 05:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Clear all unprotected cells
    By Drayde in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2014, 04:58 PM
  2. [SOLVED] Clear all unprotected Cells
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2013, 07:53 PM
  3. Clear contents of cells in a range, LEN=0
    By jenny_journalist in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-29-2009, 11:37 AM
  4. Button to clear all unprotected cells including listboxes
    By davemojo82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2009, 12:03 PM
  5. [SOLVED] Macro to clear contents of unprotected cells AND drop down boxes
    By JB2010 in forum Excel General
    Replies: 3
    Last Post: 03-30-2006, 05:15 AM
  6. clear contents cells of unprotected cells
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2006, 02:15 PM
  7. [SOLVED] Clear contents of unprotected cells in entire workbook with a macr
    By FinnGirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2005, 01:05 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