Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 'Freeze panes' disables controls

A limitation of Excel :
<From an earlier post
Whilst this refers to Office97, I still see the same in Excel 2002.
http://support.microsoft.com/kb/168392
"For an ActiveX control to appear and function properly in multiple windows
or panes of the same document, the container application must support the
IViewObject interface. Because Word, Microsoft Excel, and PowerPoint do not
support this interface (as discussed in the previous section), the behavior
of an ActiveX control that is viewed in two different windows or panes of
the same document may be unpredictable."

Seems like you're out of luck.
</From an earlier post

Not this only applies to ActiveX. If you can use the controls from the Forms
tool box, there is no issue.

NickHK

"DenisKa" wrote in message
...
Hi
When I add some controls to sheet (e.g. buttons), and use 'Freeze panes'
option then some controls become disabled. E.g.: a half of a button can be
enabled and clicked, second one is like a picture. Why does this happen?
TIA



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 Sharaf Excel Discussion (Misc queries) 1 August 25th 08 10:06 AM
Freeze Panes Darin Kramer Excel Programming 2 September 7th 06 11:36 AM
freeze panes Melissa Excel Worksheet Functions 3 July 13th 05 10:01 PM
Freeze Certain Panes Choice Excel Programming 1 May 9th 04 09:43 PM


All times are GMT +1. The time now is 01:57 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"