Copy row macro not automatically assigning macro to checkbox

Greetings everyone,

I have a 3 part macro that I have running on several sheets of a workbook. Although the code will delete the checkboxes and read them, when I click on the checkbox, nothing happens. Nothing happens at least until I manually assign the "copyrow" macro to each checkbox. Could someone please point out why the checkboxes are not being automatically assigned to proper copyrow macro? I can't figure this out. Thanks for your help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[CODE][/

Sub CopyRowsbuildcustomcarport()
Dim ws As Worksheet
Sheets("Build Custom Carport").Select
Dim callersAddress As String

Set ws = ActiveSheet
With ws.CheckBoxes(Application.Caller)
If .Value = xlOn Then
Sheet7.Range("L" & Sheet7.Rows.Count).End(xlUp).Offset(1).Resize(, 2).Value = Sheet7.Range(.TopLeftCell.Address).Offset(, -2).Resize(, 2).Value
.Value = xlOff
End If
End With
End Sub

CODE]

missed code break, oops!

Please Login or Register  to view this content.

just to clarify, this code is running successfully on three other sheets. each sheet has a different macro name associated with it. it is only on this sheet that the checkbox association has gone broken.

Haven't you already gone through this ?

There is no OnAction being assigned in the Addcheckboxesbuldcustomcarport sub.

Thanks for the reminder!