View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Deny/Allow for certain range.

Hello everyone,

I have a question and I hope to get an answer. I use a Excel spreadsheet and
I need to set it up the way that only specific range in the sheet can be used
as an active. There is range such as B1:C20, so whenever mouse is being
clicked out of that range it should not select any other cell, except for
those in the specified range. How can that be accomplished?