Excel VBA Course
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.)

View Course

need to disallow adding filters buy users

0

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 

Answer
Discuss

Discussion

Seem my Answer yet, Graham? 
John_Ru (rep: 6297) Sep 18, '23 at 11:04 am
I'll take that as a "No"!
John_Ru (rep: 6297) Sep 22, '23 at 6:36 am
Add to Discussion

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.

Discuss

Discussion

No comment, Graham?
John_Ru (rep: 6297) Sep 25, '23 at 6:45 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login