J
Jock
Hi,
Column D is locked when the worksheet is protected but the cells in that
column can be selected. If a user tries to enter text into any of the cells
in "D", the standard warning appears i.e. cell is protected and read only.
The cells can be double clicked which opens a user form into which the user
will enter the data. When that is closed, the data is transferred to the
locked cell by code.
My q is can the default warning message be replaced by one of mine for
instance informing the user to double click the cell?
Thanks.
Column D is locked when the worksheet is protected but the cells in that
column can be selected. If a user tries to enter text into any of the cells
in "D", the standard warning appears i.e. cell is protected and read only.
The cells can be double clicked which opens a user form into which the user
will enter the data. When that is closed, the data is transferred to the
locked cell by code.
My q is can the default warning message be replaced by one of mine for
instance informing the user to double click the cell?
Thanks.