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
|