row highlight code doesnt work in Shared WorkBook

[Krishnab4u]

Dear All,
Following code is to highlight the Row in the given range when a cell is selected.
This codes works perfectly alright until the time the workbook is Shared.
"Application defined or Object defined error" is shown when the workbook is Shared.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim rownnumber As Integer
'Dim AcSheet As Worksheet


rownumber = ActiveCell.Row


If Application.Intersect(ActiveCell, [DATAHEADER]) Is Nothing Then
If Application.Intersect(ActiveCell, [MAINTABLE]) Is Nothing Then
If ActiveCell.Value <> "" Then
    If ActiveSheet.Protect = True Then
    ActiveSheet.Unprotect Password:=""
    ActiveSheet.Protect AllowFormattingCells:=True
    ActiveSheet.Protect AllowFiltering:=True
    Range("B3:Z500").Interior.ColorIndex = xlNone
    Range("B" & rownumber & ":Z" & rownumber).Interior.Color = RGB(204, 255, 153)
    ActiveSheet.Protect AllowFiltering:=True
    ActiveSheet.Protect Password:=""
    Else
    ActiveSheet.Protect AllowFormattingCells:=True
    Range("B3:Z500").Interior.ColorIndex = xlNone
    ActiveSheet.Range("B" & rownumber & ":Z" & rownumber).Interior.Color = RGB(204, 255, 153)
    ActiveSheet.Protect Password:=""
    End If
End If
End If
End If




End Sub

Please help, what is wrong.

Regards
Krishnamoorthy S

 

[dmt32]

This I think you will find, just one of the many limitations of sharing a workbook and why many here would advise against using this option.

Sheet / Workbook protection in place when the workbook is shared remains in place and cannot I believe be unprotected with VBA whilst in sharing mode & this may explain the error you have. But others here may have further understanding of the issue.

You can find out more about workbook sharing by searching: “Features unavailable in a shared workbook”

Hope Helpful

Dave

 

[Fluff]

Cross posted https://www.excelforum.com/excel-pr...ight-code-doesnt-work-in-shared-workbook.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Krishnab4u]

hi, noted yours. Apologizes for not having informed about the post in another forum. Thank You.