'Assign Macro' does not show available macros

[davidam]

Hello All,
Occasionally, when attempting to edit a macro, the Assign Macro dialogue box does not list all of the available macros. Even though all macros work properly, I have always taken this as a sign of trouble and gone back a version and then proceeded forward. Does anyone know why this happens?
Thank you

 

[NoSparks]

Private macros and macros requiring parameters do not show in the dialogue box.

 

[davidam]

Private macros and macros requiring parameters do not show in the dialogue box.

That certainly has not been my experience

 

[NoSparks]

So you're saying that when you Alt+F8 and bring up the Macro dialogue box that the macros show for any event codes you are using?

 

[davidam]

Yes absolutely. Something is seriously wrong if they do not. I have exported all of the subs, saved the files as xlsb to get rid of whatever error has lodged itself in there, and, upon inserting one sub, i can now see all of the macros in that sub listed in the dialogue box. This is the procedure i guess will be using to correct my file.

 

[rlv01]

Private macros and macros requiring parameters do not show in the dialogue box.

That's been my experience as well.

 

[Fluff]

Something is seriously wrong if they do not.

I would disagree, Event code, Private subs & subs that require arguments should never appear in the dialogue box.

 

[Joe4]

By definition, adding the word "Private" hides them from that last - that is exactly what "Private" is meant to do.
And you cannot have codes that requires parameters - that has always been the case.

Also, you should put the code you want to see publicly in General modules in VBA, and not in the Sheet or Workbook modules.

Lastly, be aware of what settings you are using here:

 

[davidam]

I misunderstood NoSparks comment and it makes total sense that subs requiring parameters and Private subs should not appear as available for assignment. What I was describing is a situation where the dialogue box just forgets all macros except the one that is actually assigned to a button--a case where it should show dozens of available macros. I have seen this a few times--I don't know why it happens. In any case, my solution of exporting all of the macros, and then re-importing them did work. Thanks to all!