Add, Rename, and Delete Worksheet with VBA - Macro for Beginner

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:
Function: Macro
Business Scenario: You need to add, rename, and delete worksheets automatically

***Macro Code***
Sub AddandRenameandDeleteSheet()
ActiveSheet.Activate
'Add sheet
Sheets.Add After:=ActiveSheet
'Rename sheet
ActiveSheet.Name = "PivotTable"
'Delete sheet
Application.DisplayAlerts = False
Worksheets("PivotTable").Delete
End Sub

******Follow-up Consulting Services******

******More Videos in Playlists******

#ExcelforHR#HRAnalytics#Excel#HR

[saovithyeamuth]

Thanks you how to console data from multiple sheet in a worksheet?

[alttab]

Hello how about, self delete when someone tries to access it or copy to another location?