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 |
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 |