username

I know this has been answered but I did not understand what to do. I need to create usernames from another column. Column A will be the username. Column C is where the data is, which is the companies actual name. I need to pull the first 8 digits in the company name and have it go to...

Hi guys, Is there a way to have a formula or a VBA code associated to the choice of any value in a Validation list. For example is there a way to have lets say in A1 a validation list and to have B2 returning the username of the person of who will select a value in A1? As ususal thanks in...

Hi All, I'm keen to add a field to a spreadsheet that populates a cell with the username of the last person who edited the file, as in the system or logon name, e.g. first.lastname syntax. I would however like to keep this sheet as an .xlsx and not have it as an .xlsm. I have the code to use...

I've got a very basic understanding of VBA & I'm trying to create a spreadsheet with a timestamp along with the username when a cell within a range is modified. I've have found loads of examples of vba with different variations that're pretty close, but I can't seem to make them work for me...

Hi! On Windows I can use the following to return the username of whoever is logged into the computer: Environ("username") But this does not work on a Mac. How can I replicate this? P.S. I found something that returns the machine unique identifier but that is not what I'm looking for.

HI, I’m working to set the value of a variable to “Environ(“Username”)” but I’m getting an error about “Constant expression required” , not sure what I’m doing wrong Const computeruser = Environ("USERNAME")Any help will be much appreciated josh

I'd like to protect a small area in the excel sheet. Example H45:M47 where the user should put his/her windows username and password as authentication method through a VBA userform window. I'm not a VBA expert due to that fact the full step by step VBA code and setup will appreciate! Thanks

I've been tasked with creating an Excel-based report that will be sent to a number of individual business partners, but rather than send a number of separate versions I'd instead like the data included within to be governed by a Username and Password login form. The form itself will only...

I would like to write VBA code to log into the below (and other) sites. I would like to then navigate within those sites (clicking links) to get to different pages where I would eventually be able to download Year to Date Statements. I am struggling with determining which commands to use in...

I've seen numerous posts on this topic and have tried to adapt each of them to suit my needs, but I'm still running into errors in my code. What I'm trying to accomplish is to have certain worksheets in my workbook unhide for a specific user. I have a worksheet called "Summary" and then I have...

Hi, I am new to excel. While searching for help on codes and different ways to simplify my task i came across this forum. would be glad if someone could help me with my problem. I have a huge excel sheet with data more than 100s of rows. it's a common workbook shared by evryone in my company...

I am in need of a login user form that requires a username and password to use the file, the poor protection this method offers not withstanding, I found code that seems to work (the link is below) but the only problem i'm having with it is that even when the correct login information is entered...

When i get to work I need to login to about five different programs! sometimes taking an exorbitant amount of time, sometimes as much as ten minutes! I want to be able to click one shortcut on my desktop and open and login to most of my programs. I have done this with most of the programs I use...

Hi, If anyone could help :confused: I want the user ID to appear in a cell Public Function user() As String user = Environ("username") End Sub All works fine, but when I send it to another user they have to click on the cell for it to update.... (hope that makes sence) could anyone...

Hello, I have a spreadsheet that multiple people use and it has a button to access another spreadsheet. If that sheet is open by someone else and another user tries to open it, the macro opens it read-only and presents a message box stating that someone else is in the file and that they won't...

I'm struggling to Set a variable based on an if statement. What I want is to set the variable User = Environ("USERNAME") if the Environ("USERNAME") does not equal userB or userC. If the Environ("USERNAME") does equal userB or userC then I want User = userA. Here's what I have however I'm...

Hi - I have an Excel file that is using MS Query to pull data from Access. I am wanting to store the username's initials in a table in MS Access each time the user queries the database via MS Query. Is this possible?