View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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!