Excel VBA Save As

[shapeshiftingkiwi]

I'm trying to create a save as button in excel and adapted the below code from a video guide. However whenever I click on the button or hit the code to run, nothing happens. The macro is linked to the button and the button does "depress" to show it was clicked. What am I missing?

Sub Save_As()
With Application.FileDialog(msoFileDialogSaveAs)
.Title = "Save"
.ButtonName = "Save Form"
.InitialFileName = "C:\Users\MYNAME\OneDrive - MY COMPANY\Documents\Excel\" & Range("M3").Value
End With
End Sub

 

[Fluff]

@shapeshiftingkiwi In future please do not duplicate you questions as per board rules.
On this occasion I have merged both threads.

 

[Micron]

This one could be marked as solved then, so that others don't waste time looking for threads that need a solution?
Thanks & glad to have been of some help.

 

[Micron]

Interesting that you marked your own post as the solution. Oh well, it's not like I missed out on any $$.

 

[shapeshiftingkiwi]

Lol! My bad, got confused by the merged thread and figured something had to be marked as solved. Don't yell at me, Micron!

 

[Micron]

Never.