ExcelBanter - Easy question - Unselecting cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Easy question - Unselecting cells (https://www.excelbanter.com/excel-programming/380330-easy-question-unselecting-cells.html)

None

Easy question - Unselecting cells

Ok this is a really easy question....

Is there a way to have all seceleted cells on a worksheet
unselected? So that so cells are selected?

Chip Pearson

Easy question - Unselecting cells

Use code like the following:

Dim WS As Worksheet
Set WS = Worksheets(1)
WS.EnableSelection = xlNoSelection
WS.Protect

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"None" wrote in message
...
Ok this is a really easy question....

Is there a way to have all seceleted cells on a worksheet
unselected? So that so cells are selected?

All times are GMT +1. The time now is 05:28 PM.