Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dissallow characters
I have a form that emails a sheet and uses the input from
a cell on the sheet to name the emailed workbook. Because of this I want the user to "not" be allowed to enter certain characters that can't be part of a filename such as [ ] \/ etc into that cell. Is there a way to do this? Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dissallow characters
use data=Validation
-- Regards, Tom Ogilvy Dave wrote in message ... I have a form that emails a sheet and uses the input from a cell on the sheet to name the emailed workbook. Because of this I want the user to "not" be allowed to enter certain characters that can't be part of a filename such as [ ] \/ etc into that cell. Is there a way to do this? Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
sum of characters | Excel Discussion (Misc queries) |