#1   Report Post  
Posted to microsoft.public.excel.misc
KA KA is offline
external usenet poster
 
Posts: 10
Default Marco issue

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Marco issue

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 94
Default Marco issue

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   Report Post  
Posted to microsoft.public.excel.misc
KA KA is offline
external usenet poster
 
Posts: 10
Default Marco issue

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Marco Puzzled Excel Discussion (Misc queries) 3 July 30th 07 05:09 PM
Marco Help looper Excel Discussion (Misc queries) 2 May 12th 07 06:55 PM
marco to format top 80% NN Excel Discussion (Misc queries) 3 January 17th 06 05:51 PM
I need some help with a Marco xgunda420x Excel Discussion (Misc queries) 2 August 2nd 05 01:43 PM
Marco Loi New Users to Excel 4 December 7th 04 08:52 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"