password-protected form

**robindemey** · 03-04-2010, 08:10 PM

Hi

This is what I have to do:

Make an excel-file that can do the following:
Every evening the employees have to fill in their own hours they have worked (date, time started/finished/brake, description of work, worknumber, ...).

This should all be written into one file. BUT they all must not see anything but their own data.
Plus they must not be able to edit anything they've added before.

The boss will use this file to calculate their paycheck and also how many time it costed to make each order in the firm. That is why it should (at last) be written in one file.

What would be the best way?
Can I use a form to do that? And how do I protect it?...
I have a lot of excel experience, but nothing with macro's. I learned a little Visual Basic a few years ago.

Thanks for helping me out here.
Regards
Robin

**quekbc** · 03-04-2010, 08:32 PM

From what i know, the security in Excel is very weak. As long as they can open a workbook, they can, if they really want to, find ways and methods, to unprotect anything in Excel, VBA codes included.

Best way I can think of is to have a seperate template for everyone, then have a master sheet that compiles all info into 1 master sheet.

**royUK** · 03-05-2010, 01:53 AM

The safest option is as already suggested - use a template form only & import each completed sheet into a master workbook. The import would be relatively simple to automate with VBA.

Excel protection is weak, but strong enough to stop the average Excel user. I have posted examples of protecting a workbook & allowing access to specific sheets for individuals.