Using FreezePanes property in VB 6.0

  • Thread starter Thread starter Francis
  • Start date Start date
F

Francis

Hi all,

Can anyone tell me how to use FreezePanes in VB 6.0?
I have tried the following code, but it doesn't work.

=======================
With vobjWrkSht
.range("C9:D12").Activate
.FreezePanes = True
End With
=======================

Best regards,
Francis
 
With vobjWrkSht
.Activate
.range("C9:D12").Activate
End With
ActiveWindow.FreezePanes = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freezepanes odd behavior 1
Problems specifying where "freezepanes" occurs using VBA 2
Excel Properties() collection 9
Resize commentbox in VB 1
How to rotating a Label control in VB 6.0 to, say 90 or -90 degrees 1
VSTO Excel 2003 to VB 6.0 Type Mismatch 1
VB 6.0 to Launch excel 7
Find a value in a worksheet 5

Back
Top