Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Simple Macro | New Users to Excel | |||
link to combobox | Excel Discussion (Misc queries) | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Need Simple Macro | New Users to Excel |