|
Subject:
|
DataEntryMode in Excel
|
|
Posted By:
|
maxpotters
|
Post Date:
|
9/21/2005 10:08:33 AM
|
Hi all,
I am using DataEntryMode = xlStrict to disable user entry. However, before this code is ran, other code selects a few cells in order to let my program work correctly.
The problem is that I don't want the last selected cell to be editable (which is the case now because I selected cells before the statement. Normally, if you use the statement all cells are deselected because no other cell is selected).
Thanks in advance
Max
|
|
Reply By:
|
maxpotters
|
Reply Date:
|
10/6/2005 5:18:10 AM
|
Just for the other curious ones, here is the solution:
Cells.Locked = True (make all cells in the sheet locked)
Application.DataEntryMode = true
DataEntryMode makes it able to select unlocked cells, so the solution was dead simple (somehow didnt find it at that time).
So when locking all cells, no cell will be able to be selected.
|
