Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2021, 01:27 PM
PATRICKP PATRICKP is offline Allowing sorting by users in a protected sheet Windows 10 Allowing sorting by users in a protected sheet Office 2016
Novice
Allowing sorting by users in a protected sheet
 
Join Date: Jan 2021
Posts: 2
PATRICKP is on a distinguished road
Default Allowing sorting by users in a protected sheet

Here is my dilemma...

I have an Excel sheet that has cells where folks are not allowed to edit and others where they do need to be allowed (insert data) I understand and know how to allow access to what they should be able to do and no access to what they should not be able to do. I know how to protect the sheet with a password. Here's the rub which I can't figure out, assuming there is a way to do this.

I still need them to be able to sort the column(s) without being able to change info in the cells where they are not allowed to. For example, I want them to be able to sort company names alphabetically while not having the ability to change the name. I have checked the allow to sort/filter boxes during my setup, but still have a problem.

The problem is that when I set this up and try to filter it won't allow me to do so and asks for a password.. It comes up with something like "the sheet is password protected and you may need to enter a password" Them having to enter a password really defeats the purpose of what I am trying to do. Maybe I am missing something so I thought I would come to the pros to find out. In a nutshell, I want the sheet protected but want them to be able to filter without first having to enter a password.


Thanks in advance![/SIZE]



PS: To be more specific, I need it to allow them for example to put names in alphabetical order. I know the setup will allow them to pick a name, date, etc. but I want them to be able to have all filter functions they would have if the sheet was not protected.

Last edited by PATRICKP; 01-28-2021 at 01:56 PM. Reason: Additional thought
Reply With Quote
  #2  
Old 01-28-2021, 03:31 PM
Logit Logit is offline Allowing sorting by users in a protected sheet Windows 10 Allowing sorting by users in a protected sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

In your sorting macro, provide the password to unprotect the sheet first, before the sorting is actually done. Then password protect the sheet at the end.

If the sort will always be alphabetical, include a command button tied to the sort macro. That way the sort will occur in a blink of an eye and the user won't be able to perform any functions on the workbook ... just the sort.
Reply With Quote
  #3  
Old 01-28-2021, 05:10 PM
PATRICKP PATRICKP is offline Allowing sorting by users in a protected sheet Windows 10 Allowing sorting by users in a protected sheet Office 2016
Novice
Allowing sorting by users in a protected sheet
 
Join Date: Jan 2021
Posts: 2
PATRICKP is on a distinguished road
Default

Thank you. Now I just need to know where I find/how I make a sorting macro!
Reply With Quote
  #4  
Old 01-28-2021, 05:52 PM
Logit Logit is offline Allowing sorting by users in a protected sheet Windows 10 Allowing sorting by users in a protected sheet Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

You can search for one that fits your purposes.

You can also record a macro and use that code in a macro.

How to Record a Macro in Excel - A Step by Step Guide - Trump Excel
Reply With Quote
  #5  
Old 01-28-2021, 10:22 PM
Purfleet Purfleet is offline Allowing sorting by users in a protected sheet Windows 10 Allowing sorting by users in a protected sheet Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Upload and example worksheet and i might be able to give you a bit of a start
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting in protected worksheet john64 Excel 2 12-31-2016 12:04 PM
sorting data while in a protected workbook Andy Francis Excel 0 06-06-2015 01:35 AM
How can I let my users copy and paste into a protected Word Document? moden9999 Word 4 02-02-2015 05:39 PM
Allowing sorting by users in a protected sheet Sorting a long column and printing it on 1 sheet skbutler Excel 2 01-13-2015 05:06 PM
sheet linking, sorting nickbfe Excel 0 05-19-2006 11:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft