Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a button on Excel Toolbar
Hey guys,
I need when a workbook is opened, for it to create a button on the Excel toolbar that contains the following code.... If MsgBox("Are you sure?", vbYesNo) = vbNo Then Exit Sub End If Worksheets(1).Range("C5").Select ActiveSheet.Paste MsgBox "Data Pasted!", vbOKOnly I need this button to be visible on ANY workbook opened after this button is created. Is this possible? Thanx Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a button on Excel Toolbar
Create your macro and give it a name. Put it in a general module -
probably in Personal.xls would be good. go to tools=customize and select the second tab (commands) in the left window select macros and in the right window click and drag the custom button to the toolbar where you want the button. Right click on the button and select assign macro - optionally change the icon if you want an icon displayed. now you can close the customize dialog. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Hey guys, I need when a workbook is opened, for it to create a button on the Excel toolbar that contains the following code.... If MsgBox("Are you sure?", vbYesNo) = vbNo Then Exit Sub End If Worksheets(1).Range("C5").Select ActiveSheet.Paste MsgBox "Data Pasted!", vbOKOnly I need this button to be visible on ANY workbook opened after this button is created. Is this possible? Thanx Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a button on Excel Toolbar
Thank you
-----Original Message----- Create your macro and give it a name. Put it in a general module - probably in Personal.xls would be good. go to tools=customize and select the second tab (commands) in the left window select macros and in the right window click and drag the custom button to the toolbar where you want the button. Right click on the button and select assign macro - optionally change the icon if you want an icon displayed. now you can close the customize dialog. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... Hey guys, I need when a workbook is opened, for it to create a button on the Excel toolbar that contains the following code.... If MsgBox("Are you sure?", vbYesNo) = vbNo Then Exit Sub End If Worksheets(1).Range("C5").Select ActiveSheet.Paste MsgBox "Data Pasted!", vbOKOnly I need this button to be visible on ANY workbook opened after this button is created. Is this possible? Thanx Todd Huttenstine . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repetive Formatting/Creating a Toolbar button | Excel Discussion (Misc queries) | |||
How to modify toolbar button in excel? | Excel Discussion (Misc queries) | |||
How to modify toolbar button in excel? | Excel Discussion (Misc queries) | |||
Creating a macro that simulates some of the toolbar button | New Users to Excel | |||
need help creating "AutoSubtotal" toolbar button | Excel Programming |