Sort and filter on a protected sheet

Xtamel · #1 02-11-2024, 06:31 AM

Quote:

Originally Posted by ArviLaanemets

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.

ArviLaanemets · #2 02-11-2024, 01:13 PM

Quote:

Originally Posted by Xtamel

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!

Xtamel · #3 02-11-2024, 01:56 PM

Quote:

Originally Posted by ArviLaanemets

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.

Xtamel · #4 02-11-2024, 03:29 PM

Quote:

Originally Posted by Xtamel

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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