activesheet.unprotect

I have several protected worksheets with multiple passwords. I am not permitted to change the PW. I would like a script to unlock all the sheets so I thought of this, but it does not work. Any Ideas? Sub Un_Protect_All() awsn = ActiveSheet.Name For Each Sheet In Application.Worksheets...

I have a number of workbooks with different passwords. Sometimes worksheets within a workbook. I am not allowed to change them. So what I would like to do is loop thru all worksheets an try all the PW's But I cannot get this to work. Sub Un_Protect_All() awsn = ActiveSheet.Name For Each...

Hi I have the following code on Sheet3 of my workbook. Unfortunately, when C16 is either left blank, or "standard" is inserted, nothing happens - i.e. it does not hide rows or columns. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = True...

I have the following code, along with other VBA, attached to a command button. However, I have been told that using the ActiveSheet function can cause issues if another workbook is also open. If this is true, can someone help me piece together a better version of the below? Excel 2013 and up...

how do I get this marco to stop if there is no value in cell E3. Then let the user know that they must first enter a value in cell E3 before the marco will continue. answer = MsgBox(prompt:="Does CASH IN or CHIPS equalCHIPS OUT", Buttons:=vbYesNo + vbCritical, Title:="Update DaysValues") If...