Call user form for logged in user's cell only
Hi
I have a spreadsheet that calls user form once cell from range A1:A20 selected,these correspond to the users names.
At present whoever's logged in can select any users name from range and have user form appear.
Is it possible to only allow the logged in user to select their own name from the range and have the user form appear.
Sorry for any earlier confusion.
Last edited by Spagbog; 09-11-2011 at 10:37 AM. Reason: Incorrect description in title
I am really not clear on your data, or what that code is supposed to do, but is the username data the same as their login name?
Hi Bob
Thanks for reply
Yes the username will be the same as the log in name,at the moment whoever logs in can access and change all users holiday details.What I'm looking for is that the user can only access and change there own holidays.Once the user logs in there username is displayed in cell C1 if this is any help.The code calls up the holiday form from which they select their request then populates spreadsheet once OK selected.
Hope this helps
Thanks
Something like
Please Login or Register to view this content.
Re: Call user form for logged in user's cell only
Hi Bob
Thanks for your time I changed the Worksheet_change to WorksheetSelection_change and code is perfect,
Excellent result.
Best Regards
Spagbog
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks