Smoakstack
Board Regular
- Joined
- Mar 28, 2011
- Messages
- 79
I am trying to make my system look less like Excel and in doing so want to change the error message which excel shows when the user trys to change a locked cell. I would either like to create a new error message or have no error box at all, is this possible ?
IE: I have users pasting information into the sheet, but if they goof by copying too much and pasting into the worksheet, they get the error message of "The cell or chart that you are trying to change is protected and therefore read-only". I want a MsgBox to pop-up telling them to recopy the information correctly.
IE: I have users pasting information into the sheet, but if they goof by copying too much and pasting into the worksheet, they get the error message of "The cell or chart that you are trying to change is protected and therefore read-only". I want a MsgBox to pop-up telling them to recopy the information correctly.