running macros

[rwbaker]

Great Site!!!

I found a macro on the site that does exactly what i needed

Public Sub Jean()
' This macro will replace the first occurrence of "7"
' in each selected cell with the string "6"
' copyright 1999 www.MrExcel.com
For Each cell In Selection
cell.Value = Replace(cell.Value, "7", "8", 1, 1, vbTextCompare)
Next cell

End Sub

How can i add this as a command whenever excel is started

The name of the excel file they are running it against might change.

Can i add a custom button to excel?

thanks in advance

 

[Tuelor]

If you save it in your personal macro workbook you may use it across spreadsheets.

D