R
Rob K
Process: Creating forms in MS Excel for office us
Problem: Cannot prevent user from cutting/pasting or copying/pasting unlocked cells and/or cell formats - even when Protection for Worksheet and Workbook is activated
Example: Worksheet is protected and all but cells A1 and B1 are locked. A1 stores a dollar value and B1 stores text. It is critical that the data in these cells retain their format and value types. However, even though the worksheet and workbook protection is active, I can still drag the contents from cell A1 into B1 and as a result, mess things up
Can someone explain to me a practical way of deactivating the copy/cut commands? I'm green when it comes to VB, so coding example, if required, would be greatly appreciated.
Problem: Cannot prevent user from cutting/pasting or copying/pasting unlocked cells and/or cell formats - even when Protection for Worksheet and Workbook is activated
Example: Worksheet is protected and all but cells A1 and B1 are locked. A1 stores a dollar value and B1 stores text. It is critical that the data in these cells retain their format and value types. However, even though the worksheet and workbook protection is active, I can still drag the contents from cell A1 into B1 and as a result, mess things up
Can someone explain to me a practical way of deactivating the copy/cut commands? I'm green when it comes to VB, so coding example, if required, would be greatly appreciated.