Help with Security related to cells

[paritoshmehta]

Hi,

I have a sheet which is shared on the network so that many users ca
work on it simultaneously, but there are some cells which if ar
deleted accidentally can create a lot of problems!!!

I tried protecting the sheet, which solves the problem BUT one of th
best features in the sheet is the "AutoFilter" (this means that th
autofilter cannot be turned off...) and on protecting and then sharin
the sheet, the autofilter feature does not work!!!

If some can help me write a macro to protect the a, b and c columns s
that the cells (a1, a2,...., b1, b2...., c1, c2, ....etc. ) cannot b
altered!!!

Thanks for any help possible!!

 

[Dave Peterson]

If they disable macros/events, then this won't work.

But you could just stop them from selecting a cell in that range.

right click on the worksheet tab and select view code and paste this in the code
window:

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Me.Range("a:c")) Is Nothing Then Exit Sub
Me.Cells(Target.Row, "D").Select
End Sub

You may want to modify that range so that they can still get to the headers for
autofiltering.

 

[paritoshmehta]

Hey,

This is good, it works absolutely fine for me!!!

Thanks for your help!!!


Paritos