Disable sorting

[PetarTen]

Hi Folks,
I have a File here Filebin | 2jezz8wdpo1sm01j that needs a bit of a tweak.
It needs to have Sorting disabled and was wondering "How to do it"?

It's a xlsm file and I think I found the right Code here:
Redirecting
```vba
ActiveSheet.EnableAutoFilter = True
ActiveSheet.Protect userInterfaceOnly:=True, AllowFiltering:=True, _
AllowFormattingRows:=True, AllowInsertingRows:=True, AllowDeletingRows:=True, AllowSorting:=False
```
Unfortunately, I don't know where (and how) to add it.
Any help is much appreciated.
PS The problem is that, when the user chooses the 10 Cylinder (from A2 cell and then B2) there's no data coming up underneath A2 (BP oil)
All the rest (4, 6 and 8 Cylinder Engines) work like a charm.
I found that when change the figure to 9 (and not 10 Cylinder), the Table gives me all the requested info.
Obviously it messes with Sorting.

 

[Alex Blakenburg]

Sorry then unless the VLookup change helps, then your options for filtering out the blank rows are somewhat limited.

 

[PetarTen]

Sorry then unless the VLookup change helps, then your options for filtering out the blank rows are somewhat limited.

I've changed the Vlookup and it didn't change anything. Don't worry, I'll find a way.
I'll post a new Thread because I want to have a multiply rows for each OIL.
For instance, If you check BP on the left you see 4, 6, 8, 10 and 12 cylinder Engines.
But if you check Shell, you'll get only one Engine (one row)...and I want multiple, like in BP
Once again - thank you so much for the help
PS I don't know why ppl here are so shy and don't want to get paid, but it's a good platform for at least small Bonuses
Anyone with Revolut or Wise account can get a small Compensation for his work, right?

 

[Alex Blakenburg]

PS I don't know why ppl here are so shy and don't want to get paid, but it's a good platform for at least small Bonuses
Anyone with Revolut or Wise account can get a small Compensation for his work, right?

Nope, it's purely voluntary and against the Forum rules to take money in return
Appreciate the feedback and the sentiment though.