I have a worksheet that I reproduce every wokday for all supervisors to enter
data in. Some of these cells are merged for the sake of formatting, and have
various formats set in them that are protected. However, the protection just
ignores formats set when the user pastes information. Cells become unmerged,
previously unlocked cells become locked, and borders completely disappear.
Is there a way to disable the ability to paste information outside of values
only?
--
Burnnie Holliday
Data Wrangler