View Full Version : Solved: Sheet Tab naming on opening
BENSON
01-03-2008, 10:35 PM
I dont know if this can be done but I will ask anyway.I have a workbook that contains one work sheet named "CHECK LIST" it resides in the excel start up folder my question is :can the date be added to the sheet name when the workbook is opened ,ie the sheet name would be, if opened today "CHECK LIST 4th Jan 08 "
THANKS
Bob Phillips
01-04-2008, 02:00 AM
Private Sub Workbook_Open()
ThisWorkbook.Worksheets(1).Name = "CHECK LIST " & Format(Date, "d mmm yy")
End Sub
This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code
BENSON
01-04-2008, 02:18 AM
MANY THANKS
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.