View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 268
Default 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