Posts by ashu1990

    Re: Can't click hyperlink in locked cells.

    Try this
    Use the range to unlock the cells which contains hyperlink

    Sub test()
    Range("A1:A10").Locked = False
    ActiveSheet.Protect "pass"  ''''---->password for sheet
    End Sub

    Hope this helps

    Re: Excel Macro to Add Border to Cells in Rows Based on Criteria in Column

    try this

    if you got what you want please mark the thread as closed.

    Re: Alphanumeric Sorting for multiple columns

    try this

    sub test()
    Do While ActiveCell.Address <> Range("IV1").End(xlToLeft).Offset(0, 1).Address
    ''''your code here
    ActiveCell.Offset(0, 1).Select
    End Sub

    hope this helps