Thread: How can I set a range can't be selected!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
  
Posts: 1,092
Default How can I set a range can't be selected!
Dim MyRange As Range

Set MyRange = Worksheets("Sheet1").Range("B3:D20")
Set MyRange = Activesheet.Range("A10")
Get the idea?

Mike F
"cherishman" wrote in message
...
I want set a range(one cell or more) can't be selected, so the user can't
change the values. How can I do?




Reply With QuoteReply With Quote