[AccessD] OT: Excel Question

Thanks Jim...it was actually a 2 part...there is an EnableSelection property 
you have to set.

Thanks Again,

Mark




>From: "Hale, Jim" <Jim.Hale at fleetpride.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] OT: Excel Question
>Date: Tue, 15 Jun 2004 09:31:24 -0500
>
>If I understand your question correctly you can still get 2k to highlight
>similar rows or columns. If you hover the cursor over the column or row
>heading it turns into a  down arrow  (columns) or right pointing arrow
>(rows). When you click it will hightlight all associated columns or rows.
>For ex I have sales for the months of Jan-Apr and Gross Margin for the same
>months as columns in a pivot table. If I highlight the first Jan and click
>all Jan data for sales and margin are highlighted. HTH
>Jim Hale
>
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Monday, June 14, 2004 3:35 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] OT: Excel Question
>
>
>Hello All,
>
>I apologize for the OT...but I didn't know who else to ask.  In 
>Excel97...in
>
>a pivot table...when you click on a cell in the table it highlights all 
>rows
>
>with that same value...for example...if you had 3 unit numbers...and 4 case
>types...and built the Pivot to count all case types for each unit...then on
>the pivot click on 1 case type...all rows for that case type in the pivot
>would be highlighted.
>
>In Excel2K...this doesn't happen...only the cell you click on is
>selected...is this a setting somewhere...or is this just a functionality
>that was lost in the upgrade?
>
>Thanks,
>
>Mark
>
>_________________________________________________________________
>Getting married? Find great tips, tools and the latest trends at MSN Life
>Events. http://lifeevents.msn.com/category.aspx?cid=married
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Getting married? Find great tips, tools and the latest trends at MSN Life 
Events. http://lifeevents.msn.com/category.aspx?cid=married