Logon Box - User / Pass - Unique actions per user.

First off, it really isn't worth opening the whole XL security debate here as it's been discussed a thousand times before but let's just start off by being clear that no security in XL is watertight... if you ever have serious confidentiality issues when distributing files to multiple users - STOP - re-think - adopt an alternate approach and/or even use a different client (ie the web).

Next - I think you would need to provide some sample data so we can actually visualise how your data will be setup...

Essentially, once the user selects their name and inputs their password, I'd like the workbook to be opened and then allow them to only manipulate the row associated with their name. That row will change from week to week, so specific numbers will not be able to be used, but their name will be the same as the name used in the logon.

So for ex - does the user name appear in multiple rows or only ever one row ?
If multiple - what will be the best way to identify the appropriate row - is it always the last row for that user or is there to be a date identifier etc... ?

As a pointer, it sounds very much as though what you're looking for is a routine that will, in order, do the following:

-- Lock ALL cells
-- Find the appropriate row and unlock ONLY those cells
-- Protect the sheet

If you provide a sample I'm sure people will be able to give you what you need.

Have a look at this example

DonkeyOte - I understand that Excel is not very secure, no matter what I do - and I appreciate you stating that just in case.

Your assessment of what I'm trying to accomplish is correct:

As a pointer, it sounds very much as though what you're looking for is a routine that will, in order, do the following:

-- Lock ALL cells
-- Find the appropriate row and unlock ONLY those cells
-- Protect the sheet

I have an example of the sheet I'm using attached - to be more specific of what I'm looking for - I'd want a login box similar to that of the previous file I attached, based off the names listed. I can always add another sheet and hide it if needed with the names & passwords. I'd like the passwords to be user changeable. Once the user logs-in properly the only cells that should be changeable would be the row associated with their name - and only the columns associated with the days of the week. On my example that would be columns L through R. This would allow employees to put a "Y" in the column for the days they want to volunteer for overtime. For supervisors, they would need to access the same areas, but be able to unprotect the sheet to modify any other columns as necessary.

Thanks for the help!

CVinje

The example workbook is not protected. Disable your macros then open the workbook. The code is not protected either. From there you will see all the sheets and be able to unhide them.

Open the VB Editor (ALT+F11). You'll see all of the sheets listed in the left-hand column. Select a sheet, look down at the Properties section and change the 'Visible' property from '0 - xlSheetHidden' or '2 - xlSheetVeryHidden' to '-1 - xlSheetVisible'.

You'll then see those tabs appear in the workbook.