environusername

Hi, Hoping someone can point me in the right direction with this one.........thanks in advance. So as part of the company structure individuals have different access to spreadsheets based on their username. Some can only view certain sheets, some read only, some have full access etc etc...

Hello, I have a code which unlocks a sheet based on usernames. I've noticed that the code sometimes doesn't work because our Environ("UserName") changes from a Capital letter at the start to sometimes a lower case letter randomly. For example, "Morrisonk123" to "morrisonk123" This throws my...

I have a workbook that multiple people have their own copy of that has their Windows Username at the end of the file name (e.x. Test jdoe). Right now any time somebody new needs to use the workbook I have to manually update a few lines of code with their username. Here is an example. Dim a As...

I have a list of Usernames in column K. When a user opens the workbook I have code that checks that list, and if the current user ( Using Environ(Username)), isn't on the list it adds the user to the end of the list. If the username is already in the list it does nothing. It works great, but it...

So, I've got this code I've been using for well over a year now. Other than minor tweaks, I haven't had any issues since I've finished the project. Well, now for some reason, something has changed and I cannot figure out for the life of me what it is, or what's causing this very strange issue...