Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to: Add new sheet, then rename new sheet with todays date
With workbook already open, would like to have a macro perform:
1) add new sheet 2) rename that new sheet with todays date. Step 1 easy, completed. Need guidance on step 2 Thanks ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to: Add new sheet, then rename new sheet with todays date
Paul, something like this,
Worksheets.Add.Name = Format(Date, "mmm dd yy") Paul B "Paul" wrote in message ... With workbook already open, would like to have a macro perform: 1) add new sheet 2) rename that new sheet with todays date. Step 1 easy, completed. Need guidance on step 2 Thanks ! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to: Add new sheet, then rename new sheet with todays dat
Indeed !! that works, a large Thanks !
"Paul B" wrote: Paul, something like this, Worksheets.Add.Name = Format(Date, "mmm dd yy") Paul B "Paul" wrote in message ... With workbook already open, would like to have a macro perform: 1) add new sheet 2) rename that new sheet with todays date. Step 1 easy, completed. Need guidance on step 2 Thanks ! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to: Add new sheet, then rename new sheet with todays date
I don't know if you are familiar with VB so,
Hit Alt and F11 to open the VB editor, Click 'Insert' 'Module' In the empty screen cut and paste this into it:- Sub NewSheet() On Error GoTo Error Dim AddSheet Sheets.Add AddSheet = Format(Date, "dd mmm yy") ActiveSheet.Name = AddSheet Exit Sub Error: Application.DisplayAlerts = False ActiveSheet.Delete Application.DisplayAlerts = True MsgBox "A Sheet named " & AddSheet & " already exists." End Sub Exit the VB editor, Click 'Views' 'Toolbars' 'Forms' 'Button' to put a cammand button on the sheet, Right click the Button, select 'Assign Macro', click 'NewSheet' Rename the Button and move it where you want it and there you go, Regards, Alan. "Paul" wrote in message ... With workbook already open, would like to have a macro perform: 1) add new sheet 2) rename that new sheet with todays date. Step 1 easy, completed. Need guidance on step 2 Thanks ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
Rename sheet with NOW date | Excel Worksheet Functions | |||
Create a reference to a sheet that changes to todays date | Excel Worksheet Functions | |||
VBA rename sheet. | Excel Discussion (Misc queries) | |||
Rename Sheet | Excel Discussion (Misc queries) |