Selecting Certain Cells

M

mark1

I'm making an input sheet and I want the user to only be
able to select certain cells. I've got the sheet
protected so that a user can only enter data into certain
cells, but I can still use the mouse and select other
cells on the spreadsheet. Is there a way to do this?
Thanks!!!
 
B

Biff

Hi!

In the Protection dialogue boxes there are many options
that you can set including whether to allow users to
select locked cells. Goto Tools>Protection>Protect sheet
and a list of those options should appear. Also, you must
first select which cells are to be locked. To do this go
through the Format Cells menu and select the Protection
tab.

Biff
 
J

Jim Rech

This advice requires Excel 2002 or later. For Excel 97 and later you can
use a macro:

Worksheets("Sheet1").EnableSelection = xlUnlockedCells

The worksheet would have to be protected for this to take effect. Since
EnableSelection is not saved with the workbook it has to be reset each time
the workbook is opened.

--
Jim Rech
Excel MVP
| Hi!
|
| In the Protection dialogue boxes there are many options
| that you can set including whether to allow users to
| select locked cells. Goto Tools>Protection>Protect sheet
| and a list of those options should appear. Also, you must
| first select which cells are to be locked. To do this go
| through the Format Cells menu and select the Protection
| tab.
|
| Biff
|
| >-----Original Message-----
| >I'm making an input sheet and I want the user to only be
| >able to select certain cells. I've got the sheet
| >protected so that a user can only enter data into certain
| >cells, but I can still use the mouse and select other
| >cells on the spreadsheet. Is there a way to do this?
| >Thanks!!!
| >.
| >
 
Top