Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button to make multiple duplicate worksheets
HI! I have created a workbook with 10 worksheets and on sheets (1,2,10,4 and
6) and have put a Command Button with this Code: Private Sub CommandButton1_Click() Worksheets("Extra Earned Income Methd 1").Visible = True Sheets("Extra Earned Income Methd 1").Select Worksheets("Extra Earned Income Methd 1").Visible = True Worksheets("family totals").Range("A5").EntireRow.Hidden = False End Sub This works great to duplicate just one time per sheet, but is there a way to have it work where users can click the command Button any number of times to generate numerous multiple duplicate worksheets and still have the 2nd part of my code work where the extra row is inserted in the the worksheet titled "Family Totals"? Any help would be greatly appreciated!! ~Roxy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Ms Excel more Excel with Command Button and progress b | Excel Discussion (Misc queries) | |||
Duplicate entries in multiple worksheets | Excel Worksheet Functions | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) | |||
How do I make changes tonumersous duplicate worksheets witout havi | Excel Discussion (Misc queries) | |||
Can you delete multiple worksheets with one command? | Excel Worksheet Functions |