On Mon, 04 Jan 2010 12:48:00 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

With your workbook open hit Alr +F11 to open the VBE

That's what I needed! Thanks.

(It seems that there would be a menu item that I could eventually find
to get me here. Trying a bunch of random keystroke combinations
really isn't practical - fortunately I have you guys).

Select your workbook/project and expand it.

Do you see any modules?

Open them to see what's in them.

I found a bunch of Excel Objects sheets, Forms, Modules, & Class
modules, as well as a VBAPROJECT that wants a password.

module1 has my code.


Also check in sheet modules just in case someone stored the UDF in one of
those.

Sheet 1 contains:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Also see Bob's reply about F5 and type the name for a shortcut method to the
UDF

That would be done from the Excel window.

I replied to him.

Now I should be able to figure out what is wrong with the code.


Again, thanks.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison