add sheets

Hi all, I would like to have an excel file where I can easily navigate through the sheets. I have sheets for each week, but when I need an extra week, I would like to add a next sheet with one click. A macro is required for that. When that macro adds a new sheet, I would like the macro to...

I am running this code in another set of code. I am tring to check for all the sheets that have the same name and then see what the last number is and add 1 to the sheet number. but when it gets to sheet number 10 it wont add 1 to mane it "sheet name - 11" how do I fix this.. Const BASE_NAME...

I have a work log that is running out of sheets. I need to generate new sheets with the existing template. I also have a table at the beginning of the workbook that hyperlinks to the numbered sheet. I'm sure there is a faster way to accomplish these tasks. Please help!

Hi all. I have a code that is working as expected, but I need it on every new sheet that is added via VBA The code I need added to every new sheet is: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If CheckBox1.Value = False Then Exit Sub If (Target.Column <> 5) Then Exit Sub If...

Hallo guys, -Windows XP -Excel 2010 I need to add 3 new spreadsheets giving them a name taken from a range in another sheet. I used the code below, but after that excel creates the first new spreadsheet with the correct name, it creates the second sheet with the generic name (ex. Sheet17) and...