| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling a range of cells
I would like user to be able to go to worksheet "x". I would like for the
user to be UNABLE to select range a1:b4 and be UNABLE to activate any of the indivdual cells in that range. Any suggestions are greatly appreciated. dr chuck |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling a range of cells
In Sheet "x", unlock those cells which you want the user to be able to select
- maybe all except A1:B4. Now protect the sheet, and under the protection options, untick the Select locked cells option. "dr chuck" wrote: I would like user to be able to go to worksheet "x". I would like for the user to be UNABLE to select range a1:b4 and be UNABLE to activate any of the indivdual cells in that range. Any suggestions are greatly appreciated. dr chuck |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling a range of cells
Kassie,
Thank you very much for a simple solution to an issue that I figured would have a complicted answer. -- dr chuck "kassie" wrote: In Sheet "x", unlock those cells which you want the user to be able to select - maybe all except A1:B4. Now protect the sheet, and under the protection options, untick the Select locked cells option. "dr chuck" wrote: I would like user to be able to go to worksheet "x". I would like for the user to be UNABLE to select range a1:b4 and be UNABLE to activate any of the indivdual cells in that range. Any suggestions are greatly appreciated. dr chuck |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling a range of cells
Note: this is only working in 2002 and up
You can do it with code in 97-2000 -- Regards Ron de Bruin http://www.rondebruin.nl "dr chuck" wrote in message ... Kassie, Thank you very much for a simple solution to an issue that I figured would have a complicted answer. -- dr chuck "kassie" wrote: In Sheet "x", unlock those cells which you want the user to be able to select - maybe all except A1:B4. Now protect the sheet, and under the protection options, untick the Select locked cells option. "dr chuck" wrote: I would like user to be able to go to worksheet "x". I would like for the user to be UNABLE to select range a1:b4 and be UNABLE to activate any of the indivdual cells in that range. Any suggestions are greatly appreciated. dr chuck |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling a range of cells
The pleasure was all mine! Thanks for the response
"dr chuck" wrote: Kassie, Thank you very much for a simple solution to an issue that I figured would have a complicted answer. -- dr chuck "kassie" wrote: In Sheet "x", unlock those cells which you want the user to be able to select - maybe all except A1:B4. Now protect the sheet, and under the protection options, untick the Select locked cells option. "dr chuck" wrote: I would like user to be able to go to worksheet "x". I would like for the user to be UNABLE to select range a1:b4 and be UNABLE to activate any of the indivdual cells in that range. Any suggestions are greatly appreciated. dr chuck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling cell resizing, Unmerging cells | Excel Programming | |||
| Disabling effects of cells (temporarily) | Excel Programming | |||
| Disabling the option to move cells programatically | Excel Programming | |||
| disabling cells | Excel Programming | |||
| disabling cells based on cmd button | Excel Programming | |||
Hybrid Mode
