Hello,
Is there any way to write a macro such that a user can see whether there is someone else in the workbook at the same time? The workbook has sharing enabled on it. I tried doing some research online but couldn't find anything.
I set up a login userform that requires a person to submit their login and password to make changes to the workbook. Once the user logs in, it writes to a cell (not visible to the user), the username. Then a second user might log in with their own username and password, which would then overwrite that cell value.
This is a problem because I use the value in that cell to "stamp" their actions in the worksheet. If the second user's info is in that cell, then when the first user performs an action and stamps their username, the second user's name shows up.
Any suggestions to handle this problem would be much appreciated!
Is there any way to write a macro such that a user can see whether there is someone else in the workbook at the same time? The workbook has sharing enabled on it. I tried doing some research online but couldn't find anything.
I set up a login userform that requires a person to submit their login and password to make changes to the workbook. Once the user logs in, it writes to a cell (not visible to the user), the username. Then a second user might log in with their own username and password, which would then overwrite that cell value.
This is a problem because I use the value in that cell to "stamp" their actions in the worksheet. If the second user's info is in that cell, then when the first user performs an action and stamps their username, the second user's name shows up.
Any suggestions to handle this problem would be much appreciated!
