Hiding data validation drop downs

[JimM]

We use a spreadsheet at work that has data validation in certain cells, one of these cells is a list of suppliers.

Is there a way we can lock or hide the data validation dropdown so that when we send the sheet to an external party they can not see the other suppliers should they click in the cell.

Guessing the answer is to write some code to remove the data validation on all cells once the spreadsheet is populated but just want to check there's not something already inbuilt into Excel

Cheers

Jim

 

[MisterCrash]

In the Data Validation dialog box, uncheck the box labeled "In-cell dropdown".

 

[Weaver]

Don't think it's built in.

I've used code similar to this in the past

Sub removeValidation()
    For Each sht In Worksheets
        sht.Cells.Validation.Delete
    Next sht
End Sub

You should probably tailor it to delete any sheets you're using to store validation lists also.