Garry,

What I could do is to put the table and the results on the same page, in
separate windows, and the user could then close the second window if they
didn't want it, or it is a small table. The teams table would be separate
though still.

The line shading should be easy with CF, and I will set to landscape.

As for the VBA version, you don't know the sequence of events that caused by
any chance, I would like to fix it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

Bob Phillips Wrote:
I'll take a look at that. It's a good idea to manage the teams, better
than my suggestion.

What are the others?


My only other suggestions concern the layout of the table so I guess
this is only my particular preferences and others may disagree.

For my purposes I've been using your league table for about 6-10
players which reduces the size of the fixture grid considerably so I'd
like to have the table on the same page as the fixtures. Ideally this
need only be the 'overall & pts' columns of the table. This is simply
a practical issue when printing off a hardcopy for the office
noticeboard.

I also think the table would look better if it could have alternating
shaded backgrounds for each of rows - just to guide the eye.

The table worksheet has the default orientation as portrait rather than
landscape, by the way.

Finally I did tend to find that with the macro version of the
spreadsheet I'd get run-time errors occasionally after added/deleting
teams and once the errors had started I generally would have to resort
to an earlier version of the spreadsheet. I guess, though, this won't
be an issue with the non-macro version?

Hope I'm not sounding too picky - just take this as constructive
feedback - as I'm already very impressed with your excellent
spreadsheet and am grateful of your willingness to help. Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213