View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd Huttenstine[_2_] Todd Huttenstine[_2_] is offline
external usenet poster
 
Posts: 237
Default 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