Search:

Type: Posts; User: scockster; Keyword(s):

Search: Search took 0.00 seconds.

  1. Rick Rothstein posted this. Can you expand your help with a different sitation

    Mr. Rothstein posted an answer to this question


    I enter data in A2, B2, C2, D2.
    When i enter data in E2 i would like that A2, B2, C2 and D2 will be locked.
    When i remove the data from E2 the...
  2. Hide rows or access only specific rows based on userform login

    I have a tricky question. I have a workbook I am using for a game about 1000 people will be playing. The workbook consists of several sheets but the only sheets users will have access to is a sheet...
  3. Replies
    2
    Views
    136

    Re: Hide rows using a userform login

    I totally understand where you are coming from but I'm running a NFL knockout pool with friends so it's nothing major where I'm worried about information being leaked. These users aren't going to...
  4. Replies
    2
    Views
    136

    Hide rows using a userform login

    I have a workbook with 3-4 sheets. I havecreated a registration and a login userform. The registration userformconsists of a Reference number, Full Name, address, email, phone, etc. andallows each...
  5. Replies
    2
    Views
    251

    Re: Hide rows using a userform login

    Ok. Let me get things cleaned up and I will post it in the next few days. Thanks for your response.
  6. Replies
    2
    Views
    128

    hide rows based on a columns value

    Can anyone come up with formula that hides certain rows based on a column value?
  7. Replies
    2
    Views
    251

    Hide rows using a userform login

    Can anyone give me advice on where to get help for hiding rows based on what user you are. I have a userform where users will register and then login to access a certain sheet. Once they register it...
  8. Re: Message box is repeating with multiple worksheet changes

    I'm having trouble figuring out where to put the EnableEvents. Can you help with that please?
  9. Message box is repeating with multiple worksheet changes

    I have multiple worksheet event macros on my sheet. When selection Y/N is unlocks or locks respectively and a message box appears based on the selection. For some reason my macros 3-6 repeat the...
  10. Re: how to lock/unlock range of cells with a yes/no dropdown menu....STAT!!

    Well Dang. I know I'm probably pushing the envelope at this point but this site has been so much help. Here is my issue with the event macro. I want to start it again when you get to Row N. For...
  11. Re: how to lock/unlock range of cells with a yes/no dropdown menu....STAT!!

    Sorry, I see that Userinterfaceonly is in the code you sent me. Thank you.
  12. Re: how to lock/unlock range of cells with a yes/no dropdown menu....STAT!!

    I'm assuming just pasting it in my VBA Project is what you meant by "installing" which I did and it works great. The only thing missing is that I wanted the cells to turn black as well once...
  13. how to lock/unlock range of cells with a yes/no dropdown menu....STAT!!

    I've seen just about every form of this except the one I need for my sheet specifically.
    In Row H starting at H5 I have a drop down menu with a Y/N option and it goes all the way down to around...
  14. Re: locking drop down menus after a certain date and time

    Hey Kenny, I wanted to get back to you with little more info. So each week there will usually be 5 different times where I would need cells locked. 8:00pm on Thursday, 3 different times on Sunday...
  15. Replies
    1
    Views
    124

    locking cells after date and time

    Can anyone help with locking cells after a certain date and time. I have drop down cells made but want to lock them after a date and time passes. Do I need to set a timer??
  16. Re: locking drop down menus after a certain date and time

    I have a list of dates and times that I would like to lock these cells. It would be the day and time the game starts that I would like to lock each cell so the player cannot go back and change their...
  17. locking drop down menus after a certain date and time

    I'm running an NFL knockout pool with 750+ people and have a sheet prepared where each player has a drop down menu to choose a team every week to win and it is already validated to where they can...
Results 1 to 17 of 17