#NAME trying to find VB function?

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?

Sounds like it is in a sheet module.

Go to the VBE and do Insert=>Module

move your code to this module.

--
Regards,
Tom Ogilvy



"fedude" wrote:

> 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?

Thank you. That fixed it!

"fedude" wrote:

> 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?