Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a default Excel warning
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. -- Traa Dy Liooar Jock |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change default row numbers in Excel ? | Excel Worksheet Functions | |||
How do I change Excel default number? | Excel Discussion (Misc queries) | |||
How to change excel 2007 default name | Excel Discussion (Misc queries) | |||
Change default number to default text? | Excel Programming | |||
How do I change the default attribute in excel? | Excel Discussion (Misc queries) |