Clear Drop Down Arrows

I have a number of drop down Arrows

I have tried to clear these by selecting the cells, going to Data Validation and clear cells, but these do not disappear


I have made a screen print


It would be appreciated if someone can kindly assist me in resolving this issue

.
Go to the DATA tab, then unclick the FILTER icon. It should be highlighted at this point, until you unclick it.

Thanks Logit. I had tried this


I have attached my workbook and deleted the data at it is confidential, but left the drop down buttons (See F3 to L3), which I need to find a way to remove


Kindly advise

Someone has copied and pasted pieces of VBA code directly on the sheet.
The workbook contains a couple of Userforms and VBA code.
Best bet someone not understanding VBA has just copied and pasted the code directly into the sheet.
It seems to be well embeded I have tried and failed to remove it, the file seems corrupted.
torachan.
Capturex.JPG

Thanks for pointing this out Torachan

How do I go about locating this code , so I can try and remove it ?

Thanks for the code

I have Sales Data as well as Macro Buttons & Data Validation on the real sheet

I'm intrigued where you located this code as I had not seen it before

I was doing a number of random actions around the dropdown and the code appeared.
I have tried to replicate it and cannot, although there is a macro present that keeps hiding sections of the sheet.
@Bo_Ry's solution identifies and eliminates the immediate problem.
If you dig deeper the dropdowns are from the forms controls not from data validation.
Hopefully the problem is resolved - however some elements of mystery may still exist.
torachan.

.
FWIW ... I deleted the row to rid the drop downs.

Never found the "code" written onto the sheet though.

Hi Bo_Ry & torachan

Many thanks for all your input.

Bo_ry, you code deletes all the macro buttons as well as the arrow

If one selects Page Layout, selection Page, I get a list if items

I then click to the right on each of the drop down items and the arrows are hidden

It would be appreciated if you can kindly provide me with code to do this on sheets 3 to 10

Thanks very much for the code, Bo_Ry


It works perfectly

hi Bo_Ry

It would be appreciated if you can amend your code not to delete drop down arrows in cell B2 on sheets 3 to 10


Thanks

Howard

Hi Bo_Ry

Not sure if you saw my previous post 2 days ago. I need one more change to your code


Your assistance is most appreciated

Hi Bo_Ry


Please find sample file with drop down arrows

I only want to retain the Drop down in B2 ,which is for data validation

Many Thanks Bo-Ry


Code works perfectly