I have a protected Excel 2003 workbook with multiple protected worksheets.
Protection is set so that users can only select and edit unprotected cells.
The workbook is used by a number of people but it is not shared (each uses
their own).
Occasionally (I think unknowingly) someone will either cut and paste or drag
and drop a cells or cells which fouls hidden formulae. It doesn't cause
critical damage, but it's a nuisance when it happens. I was wondering if it
was possible to
a) disable cut and paste at the workbook or worksheet level; and
b) disable drag and drop at the workbook or worksheet level (not the
Application level)
Any help would be greatly appreciated. Thanks