Create Tabs Days Of Month w/Copy Paste Template and Open To Current Date

		Microsoft Office Forums > Microsoft Excel > Excel
Create Tabs Days Of Month w/Copy Paste Template and Open To Current Date

FAQ

Thread Tools

Display Modes

06-01-2023, 07:57 AM

p45cal

Windows 10 Create Tabs Days Of Month w/Copy Paste Template and Open To Current Date

Office 2019

Expert

Join Date: Apr 2014

Posts: 963

try:

Code:

Private Sub Workbook_Open()
Dim MyVal, sh
MyVal = Format(Date, "ddd mmm dd")
For Each sh In ThisWorkbook.Worksheets
  If sh.Name = MyVal Then sh.Select
Next
End Sub

or easier:

Code:

Private Sub Workbook_Open()
On Error Resume Next
Sheets(Format(Date, "ddd mmm dd")).Select
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Field Code to Display Specific Date of Current or Next Month	lewis255	Word	1	03-07-2023 06:13 PM
How to set date picker pop-up calendar to current month?	lafemmePJ	Word	4	02-10-2023 08:26 AM
If date is Current Month 1 or within 30 days	Sje	Excel	3	09-30-2019 10:40 PM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Create Multiple Tabs from Template	TeePee	Excel	0	04-30-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 PM.