G
Grinch
Ok!
I have an Excel application that builds up numeric data (0, 1 or 2s) in a
rectangular block of cells proceeding left to right, column by column as
time progresses. The worksheet is protected but the block of cells is
formatted as un-locked.
Occasionally if the user is not careful, a column of data might get
overlooked and gets missed out of the table. This is not a problem since
you cam manually intervene and block copy a number of columns one (or
more) columns rightwards then delete the duplicate column(s) left behind.
The missing data can then easily be inserted.
If users decide for themselves that to fix the problem they should 'cut'
and 'paste' instead (rather than 'copy' & 'paste' then 'delete') then
this has the unpleasant side-effect of removing the cell colour.
Something I want to avoid.
Can anyone suggest a way of defeating the 'cut' function (& [Ctrl]X) so
that this could not happen. An ideal solution would not permanently
affect Excel for use with subsequent workbooks.
Or, is there an alternative approach ???
Systems: Win95+Office97Pro but principally Win2000+Office2000Pro
I have an Excel application that builds up numeric data (0, 1 or 2s) in a
rectangular block of cells proceeding left to right, column by column as
time progresses. The worksheet is protected but the block of cells is
formatted as un-locked.
Occasionally if the user is not careful, a column of data might get
overlooked and gets missed out of the table. This is not a problem since
you cam manually intervene and block copy a number of columns one (or
more) columns rightwards then delete the duplicate column(s) left behind.
The missing data can then easily be inserted.
If users decide for themselves that to fix the problem they should 'cut'
and 'paste' instead (rather than 'copy' & 'paste' then 'delete') then
this has the unpleasant side-effect of removing the cell colour.
Something I want to avoid.
Can anyone suggest a way of defeating the 'cut' function (& [Ctrl]X) so
that this could not happen. An ideal solution would not permanently
affect Excel for use with subsequent workbooks.
Or, is there an alternative approach ???
Systems: Win95+Office97Pro but principally Win2000+Office2000Pro