making a login page

Hi bailymaus,

Not quite sure what you have in mind what the result should look like and/or do.

I did a few things which may are going in your direction...

- The attached workbook has pages for the Aliases (first 4 Aliases only).
- All sheets are 'very hidden', except the start page.
- When a valid Alias and matching Name are entered, the corresponding sheet becomes visible.
- When the workbook is closed, and during opening, all sheets except the login sheet are hidden again.

There is a button for Admin (password: Test) to show all sheets, so you can maintain the user register etc.


At present, anyone with basic VBA knowledge can of course unhide the hidden sheets or get to the admin password. You would need to password protect the VBA project.

Let us know if this is what you had in mind or something different.

Wow, so quick and works however a few questions,

1. How do i embed the "login" button on a webpage ?
2. How do i get the welcome to also show but with the "Name" and not the "Alias"7
3. how can I change from only the first four to perhaps 50 or more ?

Thx a lot, have tried so many methods without success.

Hi again,

Attached is a version a bit further developed;
There is now limit of 4 attempts with an incorrect password, then the file locks. This will reset to 4 after a valid login. Otherwise this can be updated on the Admin page.

To your questions;
1. Sorry, I don't know about embedding buttons to a webpage
2. On the landing page 'Welcome" you can basically have anything you want. Each user has their own page(s). All is hard-coded, no formulae
3. On the 'Admin' sheet, add the 'Alias' & Name for any additional user. Add as many as you need.

Note; the current setup is to give each user access to their own specific sheets. Therefore a new sheet needs to be added for each user. The sheet (or multiple sheets) need to start with the Alias. See example for 'Test2'.

It depends on what data and how you want to share it with the users.
- If every user has access to the same data, we only need one set of sheets that are shown when any of the users logs in with the correct credentials...

- We could have just one template sheet that populates user specific date from a hidden master sheet...

it would be helpful if you could share a bit more what the purpose of the file is. How and what data you like the users to get access to. Some sample data; master data and sample for a couple of users what they should see would also be helpful.

Hi Bailymaus,

Designing a website and an Excel file are quite different. I certainly don't have the skills or experience to help you with building a website.


Although I can't help you with a website design, some points;

So you will have a public site with general information.
A link to sign up (free or payment of a fee). Use details for username & password.
Login with username & password to gain access to other user's personal information.
Then users will see part of other users personal details. I guess that will be restricted to the other users playing the same competition (not details of all registered users).

Also, there are a lot of laws around the use and sharing of personal information. Privacy laws. Data protection against hackers. Etc.

Regards