+ Reply to Thread
Results 1 to 1 of 1

VBA timestamp that locks unlocked cells in range upon entry

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    Denver, Colorad
    MS-Off Ver
    Excel 2003
    Posts
    1

    VBA timestamp that locks unlocked cells in range upon entry

    Hi,
    I have been struggling for a few days to write a macro that upon entry of a cell labeled "reviewer/date" will lock the cells that aren't shaded gray (all unlocked). The sheet is set up as a timesheet, which records, in real time the running of microplate assays. I don't know alot about Vba, so any help would be greatly appreciated. I attached the current version that I have been working on. Once I get the macro running, I need to have about 12 other charts on the same sheet that do the same thing, but for different assays that we will be running. Essentially, once a person enters thier initials into the review cell, I need the macro to timestamp and lock all the non-gray cells in the chart. The sheet would always be protected, with only the IS department holding the pw. Ideally, the person would need a seperate personal pw to even put thier initials into the review box, and only after the validity cell reports the out put of "valid" or "invalid", but I do not know if this is even possible. I have many formulas that check the variable inputs into the chart, and these insure that all parameters of the testing are within range. We have been doing all these checks by hand and reviewing the parameters manually as well. The idea is to automate these to increase accuracy of testing. First time posting so I hope i did everything right. Thanks!

    *edit* for some reason the macro I was working on didn't save. I will try and rewrite what i had and include it when i get somewhere.
    *edit* realized its protected, working pw is 123

    timesheet.XLS
    This is sort of what I came up with while working with the macro recorder.
    Please Login or Register  to view this content.
    Last edited by twhite; 09-13-2012 at 12:54 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1