View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Prevent selecting multiple cells

Hi John

Put this in the sheet's module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target(1).Select
End Sub

HTH. Best wishes Harald

"John" skrev i melding
...
Hi everyone,

Using VBA, how may i stop more than one cell being selected in a sheet?

Thanks

John