"Frozen columns"

  • Thread starter Thread starter Tim Lypes
  • Start date Start date
T

Tim Lypes

Hello,

I do not know the right ms teminologie for that. Maybe you know a column
that is always visible inside a sheet even if the user scroll to the right
site of the sheet. I want to set the "frozen" column programmatically with
vb 2005 and office interop.
I hope you know what I mean
 
Hi Tim,

If you want to freeze column A, then

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

If you select C1, then columns A and B will be frozen, etc.

Regards,
Stefi

„Tim Lypes†ezt írta:
 
Another useful command to move the cursor to the frozen corner is

Cells(ActiveWindow.ActivePane.ScrollRow,
ActiveWindow.ActivePane.ScrollColumn).Select

:)
 

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

Excel Date Setting 1
Scrolling to top left corner when window panes are frozen 1
Dynamically Freeze Panes 1
Trying to freeze heading rows on a sheet 5
MACRO 1
Remove Split line from frozen panes 3
Postion view 2
Comments partially hidden due to "frozen" columns 2

Back
Top