Results 1 to 39 of 39

Conditional Unlocking

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    Boston, Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    87

    Conditional Unlocking

    Hello: I would like to add VBA code to a worksheet which unlocks certain cells if certain criteria are met. Basically, if cell a3 says anything other than 'New Assessment (No DC)' or is left blank, then b3:h3 should be unlocked. The same applies for a4 and b4:h4, a5 and b5:h5, and so on and so forth.

    I've found numerous examples of conditional locking/unlocking in google, but none that quite do what I'm looking to do, and I don't know VBA well enough (that is, at all really ) to modify it accordingly. Any help is greatly appreciated.
    Attached Files Attached Files
    Last edited by hektisk; 02-26-2011 at 08:24 PM.

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