View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Devin Linnington Devin Linnington is offline
external usenet poster
 
Posts: 9
Default Disabling the option to move cells programatically

I am making a workbook with sheets that have references to other sheets in
that workbook. The problem is that when you move a cell you also change the
other cells that reference to that one. This screws up my entire workbook, so
I need a way to turn off the ability to move cells. I looked around a bit an
haven't found any options, so what I need is a way to turn on/off the
movement of cells from within a VBA program. If anyone knows the command I
would love to know what it is.
Thanks,
Devin L.