How to set a value in an excel dropdown

[Zubair]

Hi

I have an excel spreedsheet where I need to select a value from a dropdown.
Due to the sheet being protected, I cant set the cell value (cant type anything)

I also tried to spy the dropdown but it only returned 1 value.

Any suggestions on what I can do?

 

[sahil_raina_91]

Hi

I have an excel spreedsheet where I need to select a value from a dropdown.
Due to the sheet being protected, I cant set the cell value (cant type anything)

I also tried to spy the dropdown but it only returned 1 value.

Any suggestions on what I can do?

Ideally you should be receiving the file as unprotected.
If that is not possible, unprotect the sheet yourself using code stage https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.unprotect