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!!!
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!!!
>.
>
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!!!
| >.
| >