Restricting use of a file

[tec4eastlake]

I have a report that I generate weekly. Our users (about 15 or 16) go into the report and add accounting details. Over the last few months, data has been damaged by users dragging their data down and sometimes over the data entered by other users.

I would like to create an AutoOpen macro that looks at the current user's Windows login, and based on that, filters the data so that people can only enter their info into their section of the database.

Not having any issues with getting the login and running it against a case statement to get the units they work for. What I'm not sure about is filtering the data down and then "locking" it so that they can't play with the filtering. I downloaded a spreadsheet from a site (can't remember the name, sorry) that shows how filtering works in VBA. It's the "freezing" part I'm having issues with. The spreadsheet is shared, so I'm not so much worried about other users seeing data that's not theirs -- the macro being AutoOpen should handle that.

Any insights or code you might have would be greatly appreciated.

Janet

 

[Yongle]

VBA could
- prevent users from meddling in original sheet
- copy "their" rows into a temporary sheet for them to add "their" accounting data
- update the original sheet
- delete temporary sheet

Which column determines which rows belong to whom?