Thread: Simple Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default 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