Restricting use of a file

tec4eastlake

New Member
Joined
Apr 30, 2019
Messages
1
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

Well-known Member
Joined
Mar 11, 2015
Messages
4,925
Office Version
365
Platform
Windows
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?
 

Forum statistics

Threads
1,085,536
Messages
5,384,294
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top