Protect a column by disabling mouse pointer
Francis,
Set the scroll area not to allow that column to be selected.
application.scrollarea = ""
I have used many other solutions also such as naming that column then using
the selection change event to check if the selection and that column overlap
and moving the selection elsewhere.
"Francis de Brienne" wrote:
Hello to all,
I am looking for a way to protect a column by not even allowing the
column to be selectedin VBA. By this I mean, I do not wish to see the
mouse pointer over the protected column.
I know this can be done, because I saw a demo once of this, but just
cant find it anymore.
thanks!
|