Inserting Worksheets
Closed
Neo
-
May 27, 2010 at 10:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:49 PM
Related:
- Inserting Worksheets
- Inserting a tick in word - Guide
- Split excel worksheets to individual files - Guide
- Inserting watermark in word - Guide
- Activeworkbook worksheets current worksheet ✓ - Excel Forum
- How to split excel sheet into multiple worksheets without vba ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 27, 2010 at 04:49 PM
May 27, 2010 at 04:49 PM
Yeah. You have to add a code to book. So when ever you open the book it looks if the sheet for that day is there or not. If not, it adds one
1. Press ALT + F11
2. PRESS CTRL + R
3. Double click on "ThisWorkbook"
4. Paste the code
1. Press ALT + F11
2. PRESS CTRL + R
3. Double click on "ThisWorkbook"
4. Paste the code
Private Sub Workbook_Open()
Dim sTodaySheet As String
Err.Clear
sTodaySheet = Format(Now, "YYYY MM DD")
On Error Resume Next
Sheets(sTodaySheet).Select
On Error GoTo 0
If ActiveSheet.Name = sTodaySheet Then Exit Sub
Sheets.Add
ActiveSheet.Name = sTodaySheet
End Sub
