We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Excel Marco

barnescs asked
Medium Priority
Last Modified: 2012-05-11
I am using Excel 2007 and have a workbook with several tabs.  I have written a macro and tied it to a button on the first sheet that allows the user to type in a name and find it in an org. chart in the workbook.  The file is saved to a folder on a server that several other people are allowed access to.  My problem is when someone else clicks on the button to run the macro they get this error message:  Cannot run macro (macro name).  The macro may not be available in this workbook or all macros may be disabled.  What do i have to do to allow other users to be able to use the macro?
Watch Question

Top Expert 2008

How are the users opening the workbook? Are they enabling macros? Are the macros actually contained in the workbook?



They are opening the workbook with Excel.  Would they be promted to enable the macros and if not, what do they do to enable them?  Yes, when i created the macro i clicked on Developer, and then Macros and then entered my macro as a VBA project.
Top Expert 2008
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

they must to change security to run this macro in the macro security menu located in the developer tab.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.