freeze rows in excel RESOLVED

freeze rows in excel RESOLVED

Postby artu01 » Wed Dec 15, 2021 4:38 am

Guys:
How can i do that?

Thanks
Last edited by artu01 on Thu Dec 16, 2021 1:41 am, edited 1 time in total.
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
artu01
 
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima

Re: freeze rows in excel

Postby Jimmy » Wed Dec 15, 2021 5:21 am

I have to look into my crystal ball ...
but I don't see a solution with so little information. :(
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1725
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany

Re: freeze rows in excel

Postby artu01 » Wed Dec 15, 2021 5:56 am

Jimmy wrote:I have to look into my crystal ball ...
but I don't see a solution with so little information. :(

:P


I want to freeze rows in Excel
For example, the first two lines of My Excel sheet are frozen
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
artu01
 
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima

Re: freeze rows in excel

Postby hmpaquito » Wed Dec 15, 2021 9:30 am

From recorded macro

Code: Select all  Expand view
Sub Macro1()
'
'
Macro1 Macro
'

'

    With ActiveWindow
        .SplitColumn = 0
        .SplitRow = 1
    End With
    ActiveWindow.FreezePanes = True
End Sub
hmpaquito
 
Posts: 1482
Joined: Thu Oct 30, 2008 2:37 pm

freeze rows in excel RESOLVED

Postby artu01 » Thu Dec 16, 2021 1:40 am

I solved this way
Code: Select all  Expand view

oWin := oExcel:ActiveWindow
oSheet:Cells( 2, 1 ):Select()
oWin:FreezePanes := .t.
 
fwh 17.12, harbour 3.2.0, pelles C, bcc7, Ms-Sql
artu01
 
Posts: 400
Joined: Fri May 11, 2007 8:20 pm
Location: Lima


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 47 guests