Hi Anna - just right click the toolbar and choose Customize. From there click the Commands tab and then click Macros in the Categories box. Choose Custom Button in the Commands box and drag it up to your toolbar. Close that screen then click the custom button to assign a macro to it. Let me know if you're on excel 2007+ as it's different.
can you post some of the code in your macro? You may have to wrap in all in a loop that only loops through the sheets you want. Or another idea is to make the sheet you don't want calculated protected. That should prevent the macro from acting on that particular sheet.
Dim WS_Count As Integer
Dim I As Integer
' Set WS_Count equal to the number of worksheets in the active
WS_Count = ActiveWorkbook.Worksheets.Count
' Begin the loop.
For I = 1 To WS_Count 'put -1 here to ignore the last sheet
' Insert your code here.
' The following line shows how to reference a sheet within
' the loop by displaying the worksheet name in a dialog box.