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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a default Excel warning
Jock,
No you can't change these messages but you could limit the risk of them being displayed by trapping column D being selected and then immediatly display your own message. Right click the sheet tab and view code and paste this in Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 4 Then MsgBox "Double click this cell to run a macro" End If End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Jock" wrote: 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 |
Reply |
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) |