+ Reply to Thread
Results 1 to 4 of 4

need macro to protect all cells which has no color and unprotect all cells wich has color

  1. 02-03-2015, 03:34 PM #1
    meonly123
    meonly123 is offline
    Registered User
    Join Date
    09-24-2011
    Location
    Yemen
    MS-Off Ver
    365
    Posts
    81

    need macro to protect all cells which has no color and unprotect all cells wich has color

    now i need to protect all worksheets which has cells with no color
    and unprotect all worksheets which has cells with color (yellow)
    thanks in advance
    Reply With QuoteRegister To Reply
  2. 02-03-2015, 07:08 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: need macro to protect all cells which has no color and unprotect all cells wich has co

    Hello meonly123,

    Try this macro...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 02-06-2015, 08:41 PM #3
    meonly123
    meonly123 is offline
    Registered User
    Join Date
    09-24-2011
    Location
    Yemen
    MS-Off Ver
    365
    Posts
    81

    Re: need macro to protect all cells which has no color and unprotect all cells wich has co

    thanks for help but it doesn't work all colored (yellow ) cells still locked


    Quote Originally Posted by Leith Ross View Post
    Hello meonly123,

    Try this macro...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 02-06-2015, 09:10 PM #4
    Trebor76
    Trebor76 is offline
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,565

    Re: need macro to protect all cells which has no color and unprotect all cells wich has co

    Hi meonly123,

    Try this:

    Please Login or Register  to view this content.
    Hi Leith,

    Happy new year!! Long time no chat. Hope all is well with you and yours.

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lock/Protect Cells based on the color of cell
    By Nisha_NishaDelhi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2014, 07:26 AM
  2. Macro to calculate date plus 18 months, check 2 other cells, and color one of those cells
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 02:46 AM
  3. Find out if a range of cells match a criteria cell, if yes, color Green, if no color Red
    By r71lima in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  4. create macro in excel to protect cells which has no color format?
    By meonly123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-29-2012, 02:06 PM
  5. Macro to unprotect sheet --> unlock cells --> protect again
    By hrhittn23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2011, 07:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1