shortcut key

[y481184]

I have another question. (Thanks for the help on the first one by the way) I wrote a lot of VB Code myself. I never actually "recorded" a macro. I placed a command button on the screen which dispays a form that I created. I would like to make the form appear with a shortcut key rather than relying on the command button. When I go to tools>macros, there are no macros in the list, so I don't know how to go about assigning a shortcut key. Any Suggetions?

 

[santeria]

When you open the Macros list, select the Macros in this Workbook option down the bottom.
Once you have that, there should be an option to do a Short Cut in the Options section of the Dialogue Box.

 

[y481184]

Sorry, I tried that and still nothing displays. I know that there are macros because I wrote the code myself. Also, when i open the worksheet I get the message "The worksheet contains macros, do you still want to open it........?" So I am not sure here. any other suggestions?

 

[santeria]

Okay... Can you get into the VBA editor, and see if you placed the Code into some sheet other than the Modules, or some other area?

The VBA Editor should show all accessable sheets in the workbook.

 

[y481184]

I'm sure thats where my problem lies. I inserted 2 forms into my project. To create the code, I just double-clicked on each form. So, my code is actually under the forms folder. There are no modules within my project. Do I need to change this?