Freezepanes odd behavior

C

Chris Dunnigan

Hello -

I have a vb 6 executable that creates an excel spreadsheet and freezes the
header rows using the following code:

oSheet.Range("A4").Select
ActiveWindow.FreezePanes = True

On one machine (under a specific user profile) the application freezes at
column "F" vertically instead of horizontally for the header rows. (defaults
to the middle)

It seems to be tied to a particular user profile on that machine because
when I login as another user on the exact same machine it works as expected.

How would the boundary of the .freezepanes be getting messed up for one user
profile? Any ideas on how to fix this?

All of our installations are Office 2003 sp2.

Thanks.
 
D

Dave Peterson

I think it depends on what was on the screen.

IIRC, I do this:

'make sure A1 is visible
application.goto oSheet.range("a1"), scroll:=true
osheet.range("a4").select
ActiveWindow.FreezePanes = False 'Just in case it's already frozen
activewindow.freezepanes = true
 

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

Top