Hi Pamela,

To use a checkbox to trigger different macros depending on whether it's checked or unchecked, you can use the following steps:

1. Right-click on the checkbox and select "Format Control" from the menu.
2. In the "Format Control" dialog box, go to the "Control" tab.
3. In the "Cell link" field, enter a cell reference where the checkbox state will be stored. For example, you can enter cell A1.
4. Close the "Format Control" dialog box.
5. Press Alt + F11 to open the Visual Basic Editor.
6. In the Project Explorer window, double-click on the worksheet where the checkbox is located (in your case, the "May" worksheet).
7. In the code window that opens, enter the following code:
   
   
   Formula:

   Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$1" Then
        If Target.Value = True Then
            'Code to run when checkbox is checked
            Range("C11:C17").Value = Range("C11:C17").Value 'Copy and paste as values
        Else
            'Code to run when checkbox is unchecked
            Range("C11:C17").Value = Range("B29:B35").Value 'Copy and paste as values
        End If
    End If
End Sub 

8. Save the workbook and close the Visual Basic Editor.

What this code does is it checks the value of cell A1 (which is linked to the checkbox) every time a change is made on the worksheet. If the value is True (i.e. the checkbox is checked), it will execute the code to copy and paste from one location. If the value is False (i.e. the checkbox is unchecked), it will execute the code to copy and paste from a different location.