View Single Post
  #1   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

sorry when i wrote that last reply the
application.scrollarea = "" ' the "" means fill in your scroll aread do not
use the double quotes as this will open the entire sheet up

"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!