Posted 12 March 2008 - 05:59 PM
Posted 19 April 2008 - 02:43 AM
Posted 19 April 2008 - 08:51 AM
Posted 20 April 2008 - 01:03 PM
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.
Posted 20 April 2008 - 03:57 PM
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
Posted 02 May 2008 - 04:12 PM
0 members, 1 guests, 0 anonymous users