Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
At the moment I use a shortcut-key for a macro. Now what I would like is a person to click a button which activates the macro instead of them using the shortcut-key. Code: -------------------- Sub SearchAndOpen() ' ' SearchAndOpen Macro ' Macro recorded 7/07/2006 by Tom Fack ' ' Keyboard Shortcut: Ctrl+r ' Dim s1 As String, bk As Workbook, bk1 As Workbook s1 = "C:\Documents and Settings\" & _ "fackt0\Desktop\Excel Probleem\Shipments\" Set bk = ActiveWorkbook If Dir(s1 & Range("J5").Text & ".xls") < "" Then Set bk1 = Workbooks.Open(s1 & Range("J5").Text & ".xls") bk.Activate Else MsgBox "workbook not found" End If End Sub -------------------- This is one of the examples which uses a shortcut-key at the moment. -- TomBP ------------------------------------------------------------------------ TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112 View this thread: http://www.excelforum.com/showthread...hreadid=559844 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Hi Tom,
I like to use a button from the Forms toolbar. Go View|Toolbars|Forms,then click on the little button icon on the Forms Toolbar then click on your worksheet. The "Assign Macro" dialog that appears should have your macro's name in the list of macros. You can either double click its name or single click it then click the OK button. After doing that your macro should run when you click the button. To make any changes to the button's appearance just right click it first. I prefer this button to the Command Button from the Control Toolbar because it works on PCs and Macs. Ken Johnson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Thx Ken. I thought it would be a whole lot of code but its as easy as getting up in the morning for work ;) -- TomBP ------------------------------------------------------------------------ TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112 View this thread: http://www.excelforum.com/showthread...hreadid=559844 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Thx Ken. I thought it would be a whole lot of code but its as easy as getting up in the morning for work ;) -- TomBP ------------------------------------------------------------------------ TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112 View this thread: http://www.excelforum.com/showthread...hreadid=559844 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Thx Ken. I thought it would be a whole lot of code but its as easy as getting up in the morning for work ;) -- TomBP ------------------------------------------------------------------------ TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112 View this thread: http://www.excelforum.com/showthread...hreadid=559844 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Thx Ken. I thought it would be a whole lot of code but its as easy as getting up in the morning for work ;) -- TomBP ------------------------------------------------------------------------ TomBP's Profile: http://www.excelforum.com/member.php...o&userid=36112 View this thread: http://www.excelforum.com/showthread...hreadid=559844 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a button to a macro
Hi Tom, At the moment I wouldn't know about that, I'm currently on holiday:-) Thanks for the feedback. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Macro To Change Which Macro Assigned To Command Button | Excel Discussion (Misc queries) | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |