Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Form Positioning with Freeze Panes

I am trying to anchor a UserForm to a particular cell. I used the code
from Vic Eldridge, from a thread "form positioning", posted
2002-05-30, which works great! Excerpted below:

hWndXLChart = FindWindowEx(hWndXLDesk, 0&, "EXCELE", vbNullString)
GetWindowRect hWndXLChart, winRect

If I use the "Freeze panes" command to fix the top 10 rows at the top
of the sheet, then this code no longer operates correctly. When I
freeze panes, the rectangle coordinates returned by GetWindowRect for
the chart window seem to be unusable. My anchor cell is in this
"frozen" area (for example, "A5").

Does anyone know how to obtain good coordinates for the chart window,
even with "Freeze panes"?

Thanks very much,

Pete
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 freeze panes won't freeze top row only macbone2002 Excel Discussion (Misc queries) 3 April 22nd 23 02:07 AM
Freeze Panes Dave Excel Discussion (Misc queries) 5 May 27th 09 09:41 AM
Freeze panes Jason Excel Discussion (Misc queries) 3 May 9th 08 06:38 PM
Freeze Panes TT Setting up and Configuration of Excel 1 April 16th 08 04:25 AM
FREEZE PANES Lucy Excel Discussion (Misc queries) 3 May 30th 06 01:16 PM


All times are GMT +1. The time now is 08:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"