+ Reply to Thread
Results 1 to 2 of 2

Lock cells in a row after input

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    San José, Costa Rica
    MS-Off Ver
    Excel 2007
    Posts
    8

    Lock cells in a row after input

    I've been working in this worksheet and now I need some help building a VB code. As you can see in the attachments in several cells I have a working userform 'asking' for a password this password is linked to a cell in the spreadsheet.

    What I wanna do now is when a user enters a correct case (same cases as used in userform 2 code, for example) all the cells before that one to lock. e.g. If a valid PIN number is entered in cell H4 cells G4, F4, D4, C4, B4 and A4 are locked, and so on for rest of the column.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-16-2011
    Location
    San José, Costa Rica
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Lock cells in a row after input

    Guys I really need some help here, somebody??

+ Reply to Thread

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