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

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

Have them go to Tools, Options, select the Security tab, click the Macro
Security button, and select Medium.


"KA" wrote in message
...
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

Thank you both of the information - works GREAT!

"M. Authement" wrote:

Have them go to Tools, Options, select the Security tab, click the Macro
Security button, and select Medium.


"KA" wrote in message
...
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