Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2008

Tip: Looking for answers? Try searching our database.

PIA and Frozen Panes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott T - 19 Mar 2008 17:01 GMT
Hello everybody!

I am writing a utility that extracts data from our databases and generates
an excel spreadsheet with PIA. I have almost all of it working, except I
cannot find documentation ANYWHERE on how to freeze a column, so that it is
always displayed, no matter the scroll position.

I could do this with the old CarlosAG 2003-XML generator, but I needed
graphing capabilities so I am using PIA for this project. As it is all
Microsoft technology, it really seems to me that there should be a way to
script such a commonly requested/required feature. My configuration is below.

OS: WXP Pro 2002 (32-bit) SP2
Environment: MS VS2005 SP1 Pro. (C#)
Excel Interop (for E2007)
Microsoft Office (Excel) Standard VLK 2007

Thank you very much

Scott
Chip Pearson - 19 Mar 2008 19:19 GMT
Select cell B1 and choose Freeze Panes.

Range("B1").Select
ActiveWindow.FreezePanes = True

Freezing panes is the only function that requires you to Select the cell
first.

Signature

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
   Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

> Hello everybody!
>
[quoted text clipped - 18 lines]
>
> Scott
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.