Art
I think the problem might be the lack of referencing in the code.
If I was doing something like I would start by opening the target workbook(s) with code, creating a reference to it when it opens
Dim wbTarget As Workbook
Set wbTarget= Workbooks("TargetWB.xlsm")
The reference that's created can then be used in subsequent code whenever we need to refer to the workbook that's just been opened.
The code for adding the button would be in the same sub that opens the workbook.
Dim wbTarget As Workbook
Dim btn As Button
Set wbTarget= Workbooks("TargetWB.xlsm")
Set btn = wbTarget.Sheets("Oct").Buttons.Add(99.6, 51, 150, 70)
btn.Caption = "Click this button to confirm you have updated " & _
"this month's data with current information " & _
"(an e-mail will be sent automatically)"
btn.OnAction = wbTarget.Name & "!CertifyEmail"
wbTarget.Close SaveChanges:=True
You could have that code in a loop for all the target workbooks, and you could even change the names to the real thing.
Bookmarks