PDA

View Full Version : help on creating new sheets



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:

lucas
03-16-2007, 07:27 AM
We provide coding assistance at VBAX not complete solutions. If you would post your workbook someone will take a look at it and get you started in the right direction.