I have a workbook with sheets for everyday of the month in it. I want to add
common command buttons that are visible and usable in every sheet. That way
it will automate some routine actions.

Right now I have six command buttons and 485 lines of code for Just One
worksheet that is not yet populated with daily meta-data.

My question is -- how do I "Share" the buttons and the code for the buttons
accross all 30 sheets without having to copy&paste them and the code into
every worksheet because if I do that then the size of the file grows and the
reaction time of the spreadsheet is decreased?

I've tried using "ThisWorkbook" and Modules but I still have to place the
buttons into everyworks sheet and then configure every button like this...

Private Sub DoThis_Click()
ThisWorksheet.SetCustomBorders
End Sub

Any help would be very nice.
Thanks in Advance,
Rob