Deny/Allow for certain range.
You can do this by applying sheet protection
Select the *entire* sheet by clicking the little square immediately to the
left of column A and immediately above row 1.
Goto the menu FormatCellsProtection tabLockedOK
Select the range of cells that you want to allow access to B1:C20
Goto the menu FormatCellsProtection tabuncheck LockedOK
Now, set the sheet protection:
Goto the menu ToolsProtectionProtect sheet
You'll see various options available to you. Since you don't want users to
be able to select cells outside of the range B1:C20 uuncheck the option:
Select locked cells and check the option: Select unlocked cells
OK out
--
Biff
Microsoft Excel MVP
"Dan" wrote in message
...
Hello everyone,
I have a question and I hope to get an answer. I use a Excel spreadsheet
and
I need to set it up the way that only specific range in the sheet can be
used
as an active. There is range such as B1:C20, so whenever mouse is being
clicked out of that range it should not select any other cell, except for
those in the specified range. How can that be accomplished?
|