Home |
Search |
Today's Posts |
#1
|
|||
|
|||
prevent a user leaving a blank cell in excel2003
I want to be able to prevent a user not filling in a required cell in a
worksheet. Anyone got any ideas? |
#2
|
|||
|
|||
Like in another thread, i think the key would be when the users tries to
leave the page. Try this in VBA:- Private Sub Worksheet_Deactivate() If Range("a1") < True Then Worksheets("sheet1").Select MsgBox "You have not completed all the details.", vbCritical, "Incomplete detail" End If End Sub It wont stop users switching to another workbook, but if you wanted it to, you could put a similar thing into the workbook module too. "Ian Varty" wrote: I want to be able to prevent a user not filling in a required cell in a worksheet. Anyone got any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
Displaying a blank cell | Excel Discussion (Misc queries) | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |