Create login screen with multiple login id and password

I have this code to track changes made in any cell by any user.

Here is the code:

Please Login or Register  to view this content.

I want to create a login screen with different id and password (to be assigned to 6 people)

Sheet "Tracker" column F shows the user.


If i create different user account in PC then it works for me.

However my PC becomes really slow if i add many users.

I have around 6 people using the excel file. So if i create 6 user account then it becomes really slow.

So i was thinking of placing a login screen in my excel file with different user id and password to track.


I know the securirty is really low in this. I know it can be manipulated easily in this

But is this possivble ?

Is it possible to create a login screen with multiple id and password to track changes by them?

I have attached my workbook

Good afternoon anilpatni1234

Are you open to different suggestions?

Have you considered setting your file up as a shared workbook? I don't normally suggest this, as shared workbooks are known to be a little flaky sometimes, but a useful side-effect is that all changes made to the can be tracked. The tracking system works based on the named assigned to the Excel installation so you can see who has made changes to each cell.

HTH

DominicB

Hi anilpatni1234

There are quite a few features that aren't supported in shared workbooks.

Most of these can be used in a shared workbook, but not changed. For example, one of these is VBA. You can used a macro in a shared file, but cannot edit it. If you need to change a module, unshare it, make your edits, then set it up as shared again.

A full list of limitations are listed here : https://support.office.com/en-us/art...2-c1c59a628534

Bear in mind, that once shared it can be unshared very easily. Create a copy of your file to experiment with and see how it works.

HTH

DominicB

Hi anilpatni1234

I'm not convinced it will speed things up, but if you want to try it, something like this should work, called from the Workbook_Open event.

It will currently expect one of two users (User1 and User2) with a password of Pass1 and Pass2.
You will need to record the uername and password somewhere so that they can be utilising in determining who has made a change. In this instance, in Sheet1, cells A1 and A2.

An incorrect username and / or password will restart the loop.

At the moment, this is pretty basic, but once you know if it has speeded up the process, you can fancy things up a bit.

Please Login or Register  to view this content.

HTH

DominicB