activesheet.unprotect

  1. W

    Worksheet Protection

    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...
  2. W

    Password unprotect sheets - multi passwords.

    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...
  3. S

    VBA - SelectionChange not working

    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...
  4. R

    ActiveSheet.Protect - Good?

    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...
  5. B

    I have this marco that i need some help with.

    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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top