 Vb.net Freeze Pane In Excel, Excel 2007 w/VS2005 |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Mar 12 2008, 05:59 PM
Post
#1
|
|
 Forum Regular  Group: Members Posts: 155 Joined: 9-December 06 From: Somewhere East of Where You Are (think about it) Member No.: 100,323  |
Are there any controls to use? Any help will be greatly appreciated. Thanks, John --------------------  |
 |
 
|
|
Apr 19 2008, 02:43 AM
Post
#2
|
|
|
New Member Group: Members Posts: 1 Joined: 19-April 08 Member No.: 203,928 |
while you writing u can format the page.
follow this and check it http://vb.net-informations.com/excel-2007/...page_format.htm |
|
|
|
|
Apr 19 2008, 08:51 AM
Post
#3
|
|
 Hail Groovicus! Group: Site Admin Posts: 5,698 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
When you have your spreadsheet open in Excel, highlight the row or columns that you want frozen. Click the view tab at the top. In the Windows section of the ribbon is an option to 'freeze panes'. Click on that, and select the first option to freeze what you selected. Click it again to unfreeze the panes.
-------------------- |
|
|
|
|
Apr 20 2008, 01:03 PM
Post
#4
|
|
|
Forum Regular Group: Members Posts: 155 Joined: 9-December 06 From: Somewhere East of Where You Are (think about it) Member No.: 100,323 |
QUOTE(groovicus @ Apr 19 2008, 08:51 AM)  When you have your spreadsheet open in Excel, highlight the row or columns that you want frozen. Click the view tab at the top. In the Windows section of the ribbon is an option to 'freeze panes'. Click on that, and select the first option to freeze what you selected. Click it again to unfreeze the panes. See, that would work, but I'm creating each spreadsheet from scratch in VB.NET. I need to be able to make the panes frozen with code control, not actually going to the sheet and doing it. The whole thing is automated, including this. -------------------- |
|
|
|
|
Apr 20 2008, 03:57 PM
Post
#5
|
|
|
Hail Groovicus! Group: Site Admin Posts: 5,698 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Something like this?
CODE Dim wb As Excel.Workbook Dim ex As New Excel.Application wb = ex.Workbooks.Add Dim sheet As Excel.Worksheet = wb.Worksheets.Add ' Select the row above of what you want to freeze sheet.Rows(2).Select() sheet.Application.ActiveWindow.FreezePanes = True ex.Visible = True I nabbed that from Experts Exchange. -------------------- |
|
|
|
|
May 2 2008, 04:12 PM
Post
#6
|
|
|
Forum Regular Group: Members Posts: 155 Joined: 9-December 06 From: Somewhere East of Where You Are (think about it) Member No.: 100,323 |
I was hoping I didn't have to go that route, with physically selecting the area. Oh well, at least it's not as bad as adding a Totals rows to the end of the data like I have to anyway. Hail Groovicus!
-------------------- |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 19th July 2008 - 08:34 PM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.