| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Select Cells Q
I have the following code, which I though would stop the ability of the
user to select locked cells, but it doesn't. It protects my sheet, but user can still select cells. Do I have something wrong? Sheets("E-Mail").Activate ActiveSheet.EnableSelection = xlNoSelection ActiveSheet.Protect Password:="1234" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable Select Cells Q
Sean,
You code works for me. But ActiveSheet.EnableSelection is not a persistent property; you have to set it every time the file is opened, may in the Workbook_Open() event. NickHK "Sean" wrote in message ups.com... I have the following code, which I though would stop the ability of the user to select locked cells, but it doesn't. It protects my sheet, but user can still select cells. Do I have something wrong? Sheets("E-Mail").Activate ActiveSheet.EnableSelection = xlNoSelection ActiveSheet.Protect Password:="1234" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| Excel 2007 Pivot Tables - Page Field Row Height; Disable Select MultItems | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Code to select 'Disable Macro' when opening an EXTERNAL FILE | Excel Programming | |||
| disable mulitple select on pivot page field | Excel Programming | |||
Hybrid Mode
