About Us

Frank Kabel

Hi Earl
I know :-)
But believe me you would get some real flames in some German newsgroups
if you use something like
So I use this email just for newsgroups and apply several filters.

"Earl Kiosterud" schrieb im Newsbeitrag
...
Microsoft recently came out with an advisory telling folks TO use
bollixed
email addresses in ng's because of the spam problem.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Frank Kabel" wrote in message
...
Hi Debra
this is one of the nice things with NG :-)
You have to constantly adapt your filters :-(

On a sidenote: though in english NG it's o.k. to use false email
addresses in most German NGs (like the German Excel NG) this is
considered against the rules (same is true for not using real
names)

"Debra Dalgleish" schrieb im Newsbeitrag
...
If you didn't use your real email address in the public
newsgroups,
maybe you wouldn't get so much XSPAM!

Dave Peterson wrote:
Yes, I did. I was distracted by some XSPAM problems.

Debra Dalgleish wrote:

I think Dave meant,... "or remove the freeze panes"

You could use WindowSplit instead

Dave Peterson wrote:

Are you using windows|freeze panes?

Is your cell with Data|validation above that line?

If yes, move the cell or remove the data|validation.

It's a bug in xl97, fixed in xl2k.

Patrick Gibbons wrote:

This is in a MS Office 97 Excel Workbook, although I have
selected data
validation for a cell the in-cell dropdown is not showing up.
Of
course
some silly person would tell me that I don't have the In-cell
Dropdown
checkbox selected . . . got it smart guy. It is still not
working.

I will give you the current setup:

Cell L4 has the current data validation:
Allow: List
Source: =$B$54:$B$65
Ignore blank - selected
In-cell Dropdown - selected

Cells B54:B65
January
February
March . . . etc.

Anyone have any ideas?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data validation with dropdown list	geotso	Excel Discussion (Misc queries)	2	February 1st 09 05:59 PM
Substition for data validation, dropdown list	Russ G	Excel Worksheet Functions	9	November 27th 07 06:26 AM
blanks in data validation list dropdown	confused	Excel Worksheet Functions	7	June 7th 06 02:10 PM
size of data validation dropdown list	Stefi	Excel Worksheet Functions	2	December 8th 05 03:36 PM
Data Validation - Dropdown List Not Appearing	MWS	Excel Discussion (Misc queries)	2	April 25th 05 05:05 PM

Menu

About Us