Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Data validation Input messages
Thanks to all who read this, your time is important: I am stuck. I
have used DATA VALIDATION in several cells of my application. Several of these cells use the INPUT MESSAGE of the DATA VALIDATION as a kind of mini Help menu. I would like to be able to offer the user the option of turning off ALL of these tips as they can become annoying after a-while. I have tried the following approach: (Only one cell here as an attempt to get it to work at all...) InvoiceEntry.Range("C15").Validation.ShowInput=Fal se It doesn't work. I have been through the object browser trying to get the heirarchy straight and it seems to me I should be able to do this, alas I cannot. If any of you MVP types out there, or anyone else for that matter, have any suggestions, I would greatly appreciate it. To restate, I want to retain the Data Validation of the cell, but remove the Input Message. Thanks again, Mark... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Input Validation | Excel Discussion (Misc queries) | |||
Validation: - different messages for defined input values | Excel Discussion (Misc queries) | |||
Editing Data Validation Input Messages | Excel Discussion (Misc queries) | |||
Can validation input messages be locked in place? | Excel Discussion (Misc queries) | |||
Creating input messages or comments | Excel Worksheet Functions |