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?