VB macros in new Excel
You could gotten there using Developer TabVisual Basic as I posted earlier.
Gord
On Mon, 04 Jan 2010 14:19:06 -0700, Howard Brazee wrote:
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.
|