i have a shared datadase that unknown users add filters to search and somehow mix up all the entries in the process is there a way to stop users addind the filters to the top row
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
need to disallow adding filters buy users
0
Answers
0
Hi Graham
Not sure if disabling filtering is possible on a shared file but do you really want to? One of the points of a database is to interrogate it to find subsets of interest from that data (and filtering is a good way).
If your "shared database" is viewed using Excel Online by users (on the Office 365 site or similar), you can't use VBA to disable filters (or clear them when the file is saved) like you could on local files..
Even if the users have to contribute to that database- you can check out this Microsoft guidance
Create and manage Sheet Views in Excel to allow a filtered view and their updates to your database.
Alternatively you might limit their access on Office 365...
Open the Excel file there and click the green Share button (top right of ribbon) then Manage Access. Under the People tab, you can set user to Can Edit or Can View (but can't save)- these people can search for their subset data but no save the "mangled" files to confuse others.
Also, under the Links tab, you can copy the "Can view" URL and send everyone that, keeping the Can Edit one secret.
Save the file and test
Hope this helps a bit.