Results 1 to 6 of 6

Autolock Cells from a Drop Down List Selection and a Calendar Selection

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    Texas, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Autolock Cells from a Drop Down List Selection and a Calendar Selection

    I need to know how to do the following in the attached spreadsheet. This is a large post, but I haven't been able to get the information I need so I wanted to be as clear as possible. When you respond, please be absolutely clear as to what to do such that somone who has never used Excel before could do it. I need to know how to do these for version 2003 at work, and for version 2010 at home.

    1. In column A, cells A2 through A60 each contain a drop down list that has 9 options: AAA, BBB, CCC, DDD, EEE, FFF, GGG, HHH, and III. I need an individual cell in A2 to A60 to be locked once any one of the 9 options is selected, and the entry cannot be changed without a password. For example, if AAA is selected in A2, A2 alone cannot be changed but A3 through A60 remain unlocked until one of the 9 options is selected in each of those cells.

    2. In column B, I need two conditions:
    Condition One, I need it such that when any cell from B2 through B60 is single-left clicked from a mouse, a calendar appears that enables to user to select a date. Once that date is selected, the date will appear ONLY in the corresponding cell AND ONCE THE DATE IS SELECTED FROM THE CALENDAR, THE CALENDAR WILL DISAPPEAR. For example, if cell B2 is single-left clicked, a calendar will appear. Once a date is selected from the calendar, the selected date will appear in B2 and the calendar will disappear. Then the same action can be done to each remaining unlocked cell from B3 through B60.
    Condition Two, once a date appears in a cell from B2 through B60, the cell is locked and the entry cannot be changed without a password.

    3. In column C, I need the same conditions for cells C2 through C60 that were applied above to A2 through A60. As you can see, the 9 option selection (AAA through III) is already programmed for C2 through C60 as well.

    4. In columns D and E, I need the same conditions for cells D2 through D60 and E2 through E60 that were applied above to B2 through B60.
    Attached Files Attached Files

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