Assign a Macro to a Button and Toolbar

Is there anyway to assign a button on a custom toolbar to a macro?

How does one do this?

I only ask because I have a macro that will only execute if the template is located in a certain directory. If I move it, I have to reassign the macro.

I was hoping there would be a way, preferably through VBA, to assign this macro dynamically.

Thanks,
meherts

I can't figure this one out and I would appreciate some help.

What I'm trying to do...
I download an excel file from an external website like 5 times a day. I want to have a custom button, in my toolbar, that takes the activeworkbook and saves the file as a specific file name, then closes the file.

Process...
On the website I click, "Download to Excel," and and excel file pops up automatically. (The file name that gets downloaded is always different, depending on the time and date. example: "0805101355.xls") I then have to click file, save as and navigate to a specific file. (THe file that I save to is always the same, "daily_sales.xls") I save as and then close the work book.
^ I want a permanant button, that always opens with excel, that does this automatically

I have a feeling this is an easy fix. I just can't figure out how to do it. I think the problem is I don't know where to put this code. I tried putting the code in the daily_sales.xls file, but it wouldn't close the original Let me know if I need to clarify anything. Thanks for the help! Ryan

Code:

 
Sub sales_save()
 
Application.DisplayAlerts = False
 
Dim name As String, name1 As String
 
name = ThisWorkbook.name
name1 = "daily_sales.xls"
 
Windows(name).Activate
    ThisWorkbook.SaveAs Filename:= _
        "C:/daily_sales.xls", _
        FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
        ReadOnlyRecommended:=False, CreateBackup:=False
 
    Windows(name1).Activate
    ActiveWindow.Close
 
 
End Sub

Has anyone created a macro to create a forms button, assign a macro and name the button? Any info would be appreciated.

This works

Code:

Sub Macro1() 
Application.CommandBars.FindControl(ID:=1849).Execute 
Application.SendKeys ("%t %h {DOWN} %n {ESC}") 
End Sub

And this doesn't

Code:

Private Sub CommandButton5_Click() 
Application.Dialogs(xlDialogValueFind).Show 
Application.SendKeys ("%t %h {DOWN} %n {ESC}") 
End Sub

Any ideas would be gratefully received

Hey guys,

as you can tell by the title I am no Macro wiz. I put together a macro which retrieves data from an excel add on called Essbase. I assign the button to the macro yet when I push the button it does nothing.

The code that ive used is identical to another work book I have which works fine. All that ive updated obviously are sheet names, ranges etc, all names are correct, but the button just doesnt work.

Has anyone seen this before? How can this be resolved?

Thanks
Dean

Hello, I've posted the below code in both "This Worksheet," and a "Module" in VBA. However, when I create a button in the spreadsheet, no existing macros appear. What am I doing wrong?

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("E1").Value "" Then
For Each X In Range("A1:D1")
If X.Value = Range("E1").Value Then
MsgBox "Found Result in:" & X.Address, vbOKOnly, "Found Result"
End If
Next
Else

End If
End Sub

Is there an easy way to assign a macro to a cell?

example: if I want to toggle hidden rows off and on, I can create a macro to hide them, but can I designate a cell where I can put an 'x' to toggle them off and/or easily unhide them . Or is there a better way?

In excel 2003 i draw a button (customize, toolbars, control toolbox). After drawing the button, when I release the mouse, I DO NOT get the assign macro prompt. What went wrong? (in the past I did assign a macro to a button, in same worksheet). Right clicking the button can get me to "view code" which is empty subroutine ready for editing...
Recently I had lots of garbage macros in this worskheet, which I deleted.

I have buttons on tabs (created from the toolbox) that I want to assign Macros to. I can click the button go to "Assign Macro" and assign the macro I want. But when I go back to the Button it doesnt have a macro assigned to it. This is happening on several tabs on several buttons (all of them). I saved, opened closed excel, the same thing keeps occuring. I even created new buttons and it happens to them as well.

Why is this happening?

Thanks
Greg