Marco issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Have them go to Tools, Options, select the Security tab, click the Macro
Security button, and select Medium.
 
Thank you both of the information - works GREAT!

M. Authement said:
Have them go to Tools, Options, select the Security tab, click the Macro
Security button, and select Medium.
Click to expand...
 
Back
Top