+ Reply to Thread
Results 1 to 2 of 2

Macro that input username

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    earth, milky way
    MS-Off Ver
    Excel 2010
    Posts
    47

    Macro that input username

    Attached is a sheet which my group at work uses to sign off on data. A user will input data, which he or she will write along the rows. That person will then click the first button in that row, and someone will later verify that row by clicking the adjacent button.

    I created this sheet to leave ample space for many possible lines, such that no one would need to modify the sheet to add more buttons.

    My request would be to set this sheet up such that rows can be added or removed, leaving the blank rows out of the sheet when they are not needed. The way I have the sheet now is with a lot of VBA, making the blank file size larger than it should be.

    Also, if you have a way to modify my purple boxes, let me know. I was going to go with checkboxes, but I cannot make the boxes larger, so this setup may be all that works. I also locked the input/verify part of the sheet as a safety measure - if you can recommend something better, please let me know.

    Thank you very very much for your help in advance. Let me know if I can clarify anything further for you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-28-2010
    Location
    earth, milky way
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Please help clean up my sheet (macros that input username)

    Any help would be greatly appreciated. I won't bump the thread again if I don't receive a response.

    Thanks

+ 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