ak1884
03-15-2007, 08:33 PM
hi to you all.
i am new on this site and also very new with vba.
The coding help that i need is for the following:
1) the 'sheet1' in the workbook is the template where details are filled in i have put a button where the user clicks 'save' when the save button is activated it must save the workbook and copy ' sheet1' into a new sheet in the same workbook but all the cells where info is filled in sheet1 must be deleted. All the new sheets that a created must be hidden.
2) A listbox placed in sheet1 that will list all the hidden sheets, and when clicked must open hidden sheets.
3) a counter on sheet1 that will count all hidden sheets.
PLEASE could you guys help i will really appreciate it.:banghead: :banghead: :banghead:
i am new on this site and also very new with vba.
The coding help that i need is for the following:
1) the 'sheet1' in the workbook is the template where details are filled in i have put a button where the user clicks 'save' when the save button is activated it must save the workbook and copy ' sheet1' into a new sheet in the same workbook but all the cells where info is filled in sheet1 must be deleted. All the new sheets that a created must be hidden.
2) A listbox placed in sheet1 that will list all the hidden sheets, and when clicked must open hidden sheets.
3) a counter on sheet1 that will count all hidden sheets.
PLEASE could you guys help i will really appreciate it.:banghead: :banghead: :banghead: