We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
Sub AnotherAttempt() Application.DisplayAlerts = False Sheets("Branches").Select Dim counter As Integer Dim SheetNamer As String Dim yourdate As String yourdate = Format(Now(), "yyyy-mm-dd") For counter = ActiveSheet.Index + 1 To Worksheets.Count Worksheets(counter).Activate SheetNamer = ActiveSheet.Name ActiveSheet.Copy ActiveWorkbook.SaveAs Filename:="H:\Test\" & SheetNamer & "|" & yourdate & ".xls" ActiveWorkbook.Close Next Application.DisplayAlerts = True End Sub
|In Excel 2007, how can I lock a value in two cells if "Yes" has been selected in a drop-down list?||7||62|
|Problem with a moving column in Excel||6||44|
|split user ID and domain name from email addresses using formula||3||18|
|how to loop through and process two columns in excel||8||25|