How to draw blue borders dynamically like pivot table?

George Wei

Guest

Posts: n/a

21st Feb 2010

Dear all,

After Added a pivot table onto a sheet, Excel will draw blue borders of its
column area, row area and data area. If you click one of the cells of the
pivot table, the blue borders are showed automatically; if the pivot table is
not focused, the borders disappear. Is there a way to implement similar
effect by programming?

Regards,
George

« Turning off display while VBA running | ActiveSheet.ShowAllData »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to keep the cell borders of the pivot table?	Á÷ÀËµÄË«Óã	Microsoft Excel Discussion	4	19th Sep 2009 02:35 PM
Remove Pivot Table Borders with Macro	BJ	Microsoft Excel Programming	0	6th Aug 2008 06:24 PM
Pivot table borders	=?Utf-8?B?U3VyZXNo?=	Microsoft Excel Setup	4	19th Dec 2005 09:12 PM
Dynamically draw table in report	=?Utf-8?B?Sg==?=	Microsoft Access Reports	4	16th Nov 2005 10:40 PM
Pivot Table Borders	Andrew Ofthesong	Microsoft Excel Programming	1	5th Aug 2003 03:06 AM