Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
'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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
Freeze panes | Excel Discussion (Misc queries) | |||
Freeze Panes | Excel Programming | |||
freeze panes | Excel Worksheet Functions | |||
Freeze Certain Panes | Excel Programming |