View Single Post
  #22   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.