Subroutine does not appear in the "Assign Macro" dialog box

[welchs101]

Hi,

I have some vba code. Several subroutines are in this code. I want to assign a macro to a forms button. I have inserted the form and when i right click on it i see the assign macro. When i click on assign macro there is a list of assignable macros.........problem is i dont see the subroutine in the list that i want. How do i get the subroutine that i want to show up in this list so i can assign it to a forms button?

[Sean Thomas]

is the sub routine marked: Private
if so remove the word private and it should appear

[AB33]

In the "macros in" menu (Above the description), there is drop down arrow. The code might be on one of "All open workbooks, personal workbooks or this workbook.

[welchs101]

the subroutine is not marked private.......

the only excel file open is the one i am working on............

what i found out is this:
i coped a subroutine from another file and pasted it into macro. closed the copied from file so only the one file is open. This new subroutine does not show up in the "assign to macro" list. However, if i go into the code and type in
"Sub XYZ"

then this "XYZ" subroutine DOES show up in the "assign to macro list"

very strange....any idea why this would be the case why a cut-n-paste routine would not show up but one i "type" in would?

[JosephP]

if your routine is declared with arguments it won't appear in the macros dialog

[AB33]

Where is the macro saved? In This workbook or Personal workbook?

[welchs101]

stored in this workbook.

JosephP. thanks this seems to fit........dont know why this is but seems to be the case. thanks.