+ Reply to Thread
Results 1 to 1 of 1

Lock following cells form user input and colour the same with grey.

  1. #1
    Registered User
    Join Date
    08-27-2017
    Location
    New Delhi, INDIA
    MS-Off Ver
    2013
    Posts
    11

    Lock following cells form user input and colour the same with grey.

    Hello!

    The below mentioned description enumerates my problems and requesting your valued expertise for its subsequent solution:

    With regards to attendance:

    Cells E2 and so on are the ordinal dates.
    The below cells have a drop down list.
    Would like to restrict/lock all the cells below from user input if "S" is entered in any cell
    in the 3rd row. Plus if the cells below could be coloured grey.(it would be best of all the cells below could be replicated with "S" as well)

    With regards to score-sheet:
    Cell F16 to O16 depicts question numbers.
    Would like to restrict/lock all the following cells from G17 to O17 from user input,based on the value "Ab" entered in F17 and to be darkened by grey colour.
    Same goes for G18 to O18 based on the value "Ab" entered in cell F18 and so on till the 10th candidate i.e. cells from G26 to O26
    should be locked based on the value "Ab" entered in F26.
    Would like to repeat the above for the forth coming sets of tests and so on (T17:AC26, AH17:AQ26 and so on, so forth).

    An excel file has been attached for our convenience.
    Thanks and regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. input box and lock the table and particular cells to user can acess
    By Anisusa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2017, 06:07 PM
  2. [SOLVED] Grey our a checkbox (not on a user form)
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-05-2014, 04:34 PM
  3. VBA User Form to change the Colour of a number of cells using a Button
    By Nathan44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2013, 12:10 PM
  4. Macro to Grey out & disable user input in a row based on first cell value
    By necrome in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 12:47 PM
  5. Cells lock after user input - based on data
    By francis.rizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 09:55 AM
  6. Lock and Grey Out Options on a User Form
    By laffers in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-07-2011, 08:31 PM
  7. Protect/lock cells after user input
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2009, 08:46 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