Why are some macros available to assign to a button and others aren't

[billfinn]

I am trying to assign a button to a new macro. I tried to insert the macro into the workbook but it ended up in the project every time. I am unable to assign the button. I would appreciate it if anyone has a link or info or an article or something that I could educate myself with in terms of macros in the project vs the workbook vs the worksheet. Trying to get myself re-educated and it's a slow process.
Thanks much,
Bill

 

[Fluff]

Assuming that your button is a forms control button (or a shape) then I would tend to put the code in a regular module.
To assign the macro to a button it cannot start with "Private Sub"

 

[billfinn]

It doesn't begin with Private Sub, and it is a Form Control buttom
Can you tell me what you mean by a regular module? Is that neither a workbook module or a worksheet module?
Also, I neglected to include the code - simple enough but I can't make the button operate it

Sub Filename_CellValue()Dim Path As String
Dim filename As String
Path = "H:\Estimator\Estimates\"
filename = Range("F14")
ActiveWorkbook.SaveAs filename:=Path & filename & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled


MsgBox "The new Estimate number is " & filename
End Sub

thanks much for the response!
Bill

 

[Fluff]

Have a look here https://www.contextures.com/xlvba01.html
It shows the various types of modules & also how to allow/enable macros

 

[billfinn]

Fluff,
Thanks very much for the reference! From what I read there I can take any macro I want to create and assign it to the workbook if the activity takes place in the workbook. I'm having heck of a time doing just that. Maybe I'll delete it and start fresh, see what that does for me..
Again, thank you. I have saved that link and will refer to it as required.
Bill

 

[billfinn]

Quick update;
I deleted the module and started from scratch. For some reason it showed up as 'Estimator Master Copy.xlsm'! Create_New_Estimate.Create_New_Estimate in the choices shown in the Assign Macro window but I'm just happy it showed up and I was able to assign a button to it.
Thanks again for the info!
Bill

 

[Fluff]

Glad you sorted it & thanks for the feedback

 

[Norie]

Bill

Don't use the same name for a sub as you've used for a module, or any other object for that matter.

 

[billfinn]

Thanks Norie!
I do try to always use distinctly different names but I appreciate the reminder!
Bill