View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Dunnigan Chris Dunnigan is offline
external usenet poster
 
Posts: 1
Default Freezepanes odd behavior

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.