Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Marco | Excel Discussion (Misc queries) | |||
Marco Help | Excel Discussion (Misc queries) | |||
marco to format top 80% | Excel Discussion (Misc queries) | |||
I need some help with a Marco | Excel Discussion (Misc queries) | |||
Marco | New Users to Excel |