Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2024, 10:39 AM
Xtamel Xtamel is offline Sort and filter on a protected sheet Windows 10 Sort and filter on a protected sheet Office 2021
Novice
Sort and filter on a protected sheet
 
Join Date: Feb 2024
Posts: 4
Xtamel is on a distinguished road
Default Sort and filter on a protected sheet

Hello,



I am working on an Excel spreadsheet where I would like it to be possible to sort while the sheet is protected, as it contains formulas and will be used by multiple users. So far, I have only managed to add a macro that allows filtering and clearing filters, but I would also like sorting to be possible.

Could you help me, please?
Attached Files
File Type: xlsm TEST Sort and Filter.xlsm (27.2 KB, 3 views)
Reply With Quote
  #2  
Old 02-11-2024, 01:20 AM
ArviLaanemets ArviLaanemets is offline Sort and filter on a protected sheet Windows 8 Sort and filter on a protected sheet Office 2016
Expert
 
Join Date: May 2017
Posts: 857
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

When you protect the sheet, there are a lot of additional options you can set for protected sheet. As much as I remember, allowing the sorting is one of them!
Reply With Quote
  #3  
Old 02-11-2024, 06:31 AM
Xtamel Xtamel is offline Sort and filter on a protected sheet Windows 10 Sort and filter on a protected sheet Office 2021
Novice
Sort and filter on a protected sheet
 
Join Date: Feb 2024
Posts: 4
Xtamel is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
When you protect the sheet, there are a lot of additional options you can set for protected sheet. As much as I remember, allowing the sorting is one of them!
dont work because i have a macro that add a line and protect the sheet again. So, i dont know what to do.
Reply With Quote
  #4  
Old 02-11-2024, 01:13 PM
ArviLaanemets ArviLaanemets is offline Sort and filter on a protected sheet Windows 8 Sort and filter on a protected sheet Office 2016
Expert
 
Join Date: May 2017
Posts: 857
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Xtamel View Post
dont work because i have a macro that add a line and protect the sheet again. So, i dont know what to do.
I think it is possible to set those protection options using VBA (I'm not sure, but probably I did it a couple of years ago - but this file was lost after our network admin's reorganised our server park. I think I remember, that there was no proper help in Excel, and I had to do a lot of search in Google to get the info bit-by-bit.
But in case you really use macros instead of VBA, then I'm not sure this is a way to go for you. Macros are quite limited tool!
Reply With Quote
  #5  
Old 02-11-2024, 01:56 PM
Xtamel Xtamel is offline Sort and filter on a protected sheet Windows 10 Sort and filter on a protected sheet Office 2021
Novice
Sort and filter on a protected sheet
 
Join Date: Feb 2024
Posts: 4
Xtamel is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
I think it is possible to set those protection options using VBA (I'm not sure, but probably I did it a couple of years ago - but this file was lost after our network admin's reorganised our server park. I think I remember, that there was no proper help in Excel, and I had to do a lot of search in Google to get the info bit-by-bit.
But in case you really use macros instead of VBA, then I'm not sure this is a way to go for you. Macros are quite limited tool!
I´m using macros because i dont know how to use VBA properly ;_;. I dont mind if somebody can help me.
Reply With Quote
  #6  
Old 02-11-2024, 03:29 PM
Xtamel Xtamel is offline Sort and filter on a protected sheet Windows 10 Sort and filter on a protected sheet Office 2021
Novice
Sort and filter on a protected sheet
 
Join Date: Feb 2024
Posts: 4
Xtamel is on a distinguished road
Default

Quote:
Originally Posted by Xtamel View Post
I´m using macros because i dont know how to use VBA properly ;_;. I dont mind if somebody can help me.
Finally I find a way to do it, maybe its not the best, but it helps me at the moment.

If someone Knows another better I would like to hear about it
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort and filter on a protected sheet Sort Filter Problem PomDave Excel 3 01-27-2022 03:36 AM
SORT() and FILTER() functions missing Ricko_uk Excel 5 08-24-2020 11:44 AM
Size of filter sort box and open at 1st available row for new data. mobile Excel 0 10-23-2016 03:39 AM
Filter, Sort, Macro... what to do? zingle Excel 3 10-17-2015 06:49 AM
Forgotten Sort and Filter Criteria rbdmg Mail Merge 0 10-31-2011 09:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:32 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