#NAME trying to find VB function?

[Guest]

Hi guys. I'm new to excel programming and I wrote a macro by Alt-F11. Now
when I access it from the worksheet I get a #NAME exception. This worksheet
is the 4th worksheet in the workbook if that matters.

In the editor in the obect dropdown list it says (General) and in the
procedure drop-down list it says the name of my function. The procedure
shows up when I select (General) or Worksheet in the object dropdown.

Do I have to enable VB or something?

 

[Guest]

Sounds like it is in a sheet module.

Go to the VBE and do Insert=>Module

move your code to this module.

 

[Guest]

Thank you. That fixed it!