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

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

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

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

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