View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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