Assign a Macro to Button / Shape Problem

[gheyman]

I usually will add a rectangle to my sheets and use them as buttons. I assign Macro's to them by right clicking the shape and then click Assig Macro from the list that appears.

But now when I click the Assign Marco and the window appears, it is blank. It is not showing all the macros I created. Therefore I cannot select one to assign. Any ides why there are no Macros showing? I have a tone in this workbook. Even when I change the "Macros in:" list it doesn't show any Macros. I tried All Open Workbooks, This Workbook....

I have several other tabs with "buttons" that I created several days ago. now when I go to Select Macro for those - it is blank as well.

Any help is always appreciated.

 

[Siddharth Rout]

Check if you have added Private before the procedure. Something like Private Sub YourProcedure()

 

[gheyman]

I dont belive that is it.

example:

Sub PopulateSelect()
'Auto Populate the Select column based on the value in the Cons Qty Match Column
Sheets("Step 5").Select
UserForm3.Show

End Sub

plus I have a bunch of Macros. I also checked that I am not in Design mode (which I read could be the problem).

 

[Siddharth Rout]

Try this

Excel macros disappeared

My Excel file had a load of macros and now when I click Developer - Macros, they don't show up in the list, the list is empty. How do I fix?

stackoverflow.com