ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent multiple cell select (https://www.excelbanter.com/excel-programming/304705-re-prevent-multiple-cell-select.html)

William[_2_]

Prevent multiple cell select
 
Hi Spaan

Try placing the code below in a worksheet module...

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


--
XL2002
Regards

William



"Spaan" wrote in message
...
| Is it possible to prevent a user from selecting more than one cell at a
time?




All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com