+ Reply to Thread
Results 1 to 2 of 2

Unlock rows depending on the user, vba

  1. #1
    Registered User
    Join Date
    04-02-2020
    Location
    Bratislava
    MS-Off Ver
    2016
    Posts
    80

    Unlock rows depending on the user, vba

    Hello all,
    I got this macro which inserts a form where a user will log in and will show his personal sheet.
    My purpose now is to use this same macro for a vacations tracker, so if you log in with your credentials the macro will unlock just your row to modify it.

    It would be possible??

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,712

    Re: Unlock rows depending on the user, vba

    Hey lasher18,

    You can do it like below ... This is just an example which you need to adjust based on your file. I believe you would need to place it the in the log-in user form & this is where you'd pass the user name to look-up the row

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lock unlock cell depending condition
    By IGORRRRR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2020, 02:32 PM
  2. Adding rows depending on user input
    By haitham1984 in forum Excel General
    Replies: 0
    Last Post: 11-10-2008, 07:30 AM
  3. Adding Rows depending on user input
    By haitham1984 in forum Excel General
    Replies: 0
    Last Post: 11-09-2008, 02:35 AM
  4. Adding rows and embedded formulas depending on user input
    By haitham1984 in forum Excel General
    Replies: 5
    Last Post: 11-06-2008, 11:04 AM
  5. MAcro to lock and unlock cells depending on rows selected.
    By ballack in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2007, 11:04 PM
  6. [SOLVED] Prevent User to unlock Sheet Tabs
    By Param in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2006, 09:50 PM
  7. Lock and unlock cells conditionally depending on input in another
    By Frustrated in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2005, 11:40 AM

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