View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fedude fedude is offline
external usenet poster
 
Posts: 74
Default #NAME trying to find VB function?

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?