Simple Macro
 

Hello,

I have made a simple Macro that when the button is clicked on it copies and
pastes the entire page into a new tab. Fantastic, but it doesn't copy my
checkboxes.
None of the checkboxes have any macro's etc. They are simply there to be
checked (manually) once the activity has been carried out.

I'd like to know if there is another command that copies the checkboxes as
well - I have about 50 on the page.

Thanks for any help - below is my command.

Private Sub CommandButton1_Click()
Cells.Select
Selection.Copy
Sheets("Template").Select
Sheets.Add

ActiveSheet.Paste

End Sub

Simple Macro
 

John,

Try copying the sheet rather than the cells:

Private Sub CommandButton1_Click()
ActiveSheet.Copy After:=Sheets(ActiveSheet.Index)
End Sub

HTH,
Bernie
MS Excel MVP


"John" wrote in message
...
Hello,

I have made a simple Macro that when the button is clicked on it copies and
pastes the entire page into a new tab. Fantastic, but it doesn't copy my
checkboxes.
None of the checkboxes have any macro's etc. They are simply there to be
checked (manually) once the activity has been carried out.

I'd like to know if there is another command that copies the checkboxes as
well - I have about 50 on the page.

Thanks for any help - below is my command.

Private Sub CommandButton1_Click()
Cells.Select
Selection.Copy
Sheets("Template").Select
Sheets.Add

ActiveSheet.Paste

End Sub