frank_m
11-12-2011, 07:32 AM
(1) I have Range("A1:Z9") merged. When selected, Excel treats it as being Cell A1.
- It contains a value. Lets say that value is "My Value in Cell A1".
(2) I also have the sheets selection change event turning sheet protection off if that merged cell is selected.
(3) The sheet is (protected again) when any other cell is selected.
That command is also handled in the selection change event.
(4) --- What is the code that I can use in the Sheets change event that will undo any change that is made in that merged cell(?)- The undo routine would be triggered when the selection is moved out of the merged cell to any other cell.
- It contains a value. Lets say that value is "My Value in Cell A1".
(2) I also have the sheets selection change event turning sheet protection off if that merged cell is selected.
(3) The sheet is (protected again) when any other cell is selected.
That command is also handled in the selection change event.
(4) --- What is the code that I can use in the Sheets change event that will undo any change that is made in that merged cell(?)- The undo routine would be triggered when the selection is moved out of the merged cell to any other cell.