I not able select multiple items from drop down list

Question

Hi all,

Need some advise on drop down list.

I am not able to select multiple items from the drop down list but my colleague can with the similar file.

The file is save in XLSM format.

I have checked the Trust Center, the Macro setting is enabled.

The Properties => attributes of that particular file is unblock.

I did googled online and was advise to use VBA which I am not familiar with.

Thank you.

Answer 1

Is there any error or notice received? Could you share a screenshot?

Answer 2

Thanks for the reply.

I followed the instruction but i m still not able to get it working.

Thank you

Answer 3

It could be your macro is still disabled. You may try steps in this link for different Scenarios.

Macros from the internet are blocked by default in Office - Microsoft 365 Apps | Microsoft Learn

You may add a trusted location and put that file in trusted location.

Add, remove, or change a trusted location in Microsoft Office - Microsoft Support