Hi,

You will have to tell the users who are not able to access the boxes to set
their macro security to medium. Tools ... Macros ... Security ... Medium.

You will have to close the excel application and restart the sheet and
select enable macros for this to work.

Regards

"KA" wrote:

I have a spreadsheet that using drop - down boxes and some of my users can
not use the drop down. When the spreadsheet open the users who can use the
drop down are ask if they want to enable marco the users who can not access
the drop down are not ask this question. How to I fix the users who can not
use the drop down menu on this spreadsheet?

Thank you in advance for your help,

Kathy