preventing reference to a particular cell
 

Is there a means of preventing references to a particular cell or range of
cells?
What I am trying to do is prevent any unlocked cells in a protected workbook
from being able to reference any locked cells.
--
Jim O

preventing reference to a particular cell
 

There is no way to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jim O" wrote in message
...
Is there a means of preventing references to a particular cell
or range of
cells?
What I am trying to do is prevent any unlocked cells in a
protected workbook
from being able to reference any locked cells.
--
Jim O

preventing reference to a particular cell
 

Chip

Is there a way to prevent the active cell from being a formula? Data entry
only?
--
Jim O


"Chip Pearson" wrote:

There is no way to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jim O" wrote in message
...
Is there a means of preventing references to a particular cell
or range of
cells?
What I am trying to do is prevent any unlocked cells in a
protected workbook
from being able to reference any locked cells.
--
Jim O

preventing reference to a particular cell
 

No, there is no way to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jim O" wrote in message
...
Chip

Is there a way to prevent the active cell from being a formula?
Data entry
only?
--
Jim O


"Chip Pearson" wrote:

There is no way to do this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Jim O" wrote in message
...
Is there a means of preventing references to a particular
cell
or range of
cells?
What I am trying to do is prevent any unlocked cells in a
protected workbook
from being able to reference any locked cells.
--
Jim O

preventing reference to a particular cell
 

Jim O,

You might be able to get close with the following
code entered into the worksheet module.
There are always ways around code like this, but it could help...
'----------------------
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrorHandler
Application.EnableEvents = False
'Change range address to the appropriate cells.
If Not Application.Intersect(Target(1), Me.Range("B5:D10")) Is Nothing Then
If Asc(Target(1).Formula) = 61 Then Target(1).Formula = "No formulas here" 'or vbNullString
End If
ErrorHandler:
Application.EnableEvents = True
End Sub
'------------------------

Jim Cone
San Francisco, USA


"Jim O"
wrote in message
...
Chip
Is there a way to prevent the active cell from being a formula? Data entry
only?--
Jim O