nested toggle boxes that hide/unhide rows??

Hi, I'm very new to excel programming and I've found this site super useful, so thanks in advance.

I need to ask a question of my own because my toggle boxes are going crazy.

I would like to have a toggle box that hides/unhides a few rows that also have toggle boxes in them. I have started with the first few rows and it works fine, but when i add a toggle box that hides those rows, they all move down into the next row on top of each other!

I'm guessing that when I place the toggle box in a cell, its not actually "in" that cell, but just on top of it? and I think that's my problem, but I have no idea how I could solve it.

In the picture, there should be toggle boxes next to each line of green text, but they have all stacked on top of each other next to the orange line of text. Even when I move them back to their proper spot they do not work anymore.

Any ideas??

Thanks so much for your reply
sorry yeh i meant toggle button, in the activex control

I've selected 'dont move or resize with cells' and the buttons are working now which is great!
except I would like them to move inline with the green text and be hidden if the green text is hidden.

ill upload the workbook, its a bit difficult for me to explain

basically im trying to hide/unhide in groups, like this

orange
green
blue
blue
green
blue

yep that's exactly what i want it to do

i would like to use something that is user friendly, so that a button or something is next to the words
is there a way to use a button to control the group outlines, so that the button does the same function as the group outline button on the side?

maybe theres something wrong with my vba code or the toggle buttons aren't meant to work that way...

yeh i will be using different colours for the different levels

Thanks heaps i tried to continue with the coding but it seems excel just doesn't like hiding buttons..
i like the idea of using the group outlines so I've made buttons that display the whole group level which is working fine!

If ToggleButton1.Value = True Then
ActiveSheet.Outline.ShowLevels RowLevels:=2
Else
ActiveSheet.Outline.ShowLevels RowLevels:=1
End If

I wonder if it is possible to label the group outlines, so that you can see what section you are hiding/unhiding?
Haven't found anything so far

hmmm weird thing i found out, if you select 'move AND resize with cells' the toggle buttons hide/unhide properly without jumping around when they are hidden. however they also resize when the rows are expanded which looks ridiculous haha, but if i select 'move and DONT resize' then they jump around again..

any way to get the best of both worlds?

Just offering this as an alternative. Would using a treeview work for you? see: http://www.cpearson.com/Excel/foldertreeview.aspx for an example.

Originally Posted by humdingaling

treeview is for file structure (folders/subfolders/files)...how would you alter that to be information from sheet?

A treeview can be used to display a file structure, but it is just a visual way to present outlined information and that is what I am interpreting the OP's goal to be.

awesome, i've learnt heaps so far and I can't thank you guys enough