Formatting tabs in a workbook

G

Glen

Is it possible to format a workbook so that a tab is set for each day of the
month? I do daily reports on excel and I would like the fromat to
goautomatically throughout the workbook.
 
P

papou

Hello Glen
If you mean automatically create new workbook and name worbook tabs with
numbers from 1 to number of days in month, this could be done with some
programming.

HTH
Cordially
Pascal
 
G

Gord Dibben

Such code would look like this. No error-trapping included.

Assumes workbook is new with no tab names other than the standard Sheet1, 2, 3
etc.

Sub Add_Sheets()
For i = 30 To 1 Step -1
Worksheets.Add.Name = "April " & i
Next
End Sub

Adapt to suit for the month in use.

If not familiar with VBA code and macros visit David McRitchie's "getting
started" pages.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Gord Dibben Excel MVP
 
Top