Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
Maybe someone has a hint for me whats wrong here :-) I have written some VBA code that allows to expand/collapse a previously grouped set of rows dependent of the state of a checkbox object. Works fine sofar. Then I have placed a CommandButton within that group, used the TopLeftCell Property to decide if the button is within the group range and if yes, hide the CommandButton when collapsing the group with the .visible property. Still works fine. The problem occurs if I save and close the worksheet while the respective group is collapsed (showDetail property = false). If I do this, after re-opening the workbook the CommandButton has changed its position, obviously messing up the worksheet layout completely. I have to confess I am a VBA newbie, maybe I have a fundamental conceptual error here- or is this simply a strange excel behavior? Any help or hint would be much appreciated!! Thanks peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cant insert a row it says cant move objects off sheet? | Excel Discussion (Misc queries) | |||
Cannot move objects off sheet | New Users to Excel | |||
Warning - "Fixed objects will move" | Excel Worksheet Functions | |||
Why can't I resize/move objects in XL XP chart? | Excel Discussion (Misc queries) | |||
Fixed objects will move | Excel Programming |