Macro will run when I hit f5 in VB, but will not run from excel

**Gard5096** · 09-06-2012, 11:41 AM

The macro I created will run when I open the module in VB and click f5, so I know the coding is accurate. The problem is when I go to the alt+f8 screen in excel and highlight the macro, none of the options are available to click (Run, Step Into, Edit, Delete...). The assigned hot key will not execute the macro either. Note: I created the macro on my PERSONAL.XLSB.

Please assist.

Thank you,

Nick

**JosephP** · 09-06-2012, 11:56 AM

what's the code-specifically the declaration line of the routine-and which module is it in (name and type)?

if the routine has a name that is a cell reference you will have that behavior

**Gard5096** · 09-06-2012, 12:42 PM

Thanks, changing the name of the macro seemed to fix the problem. Maybe it didn't like that the name started with a number, or the fact that the name replicated an existing variable.