hide and expand rows with a +/- button

J

john

Hi Guy

Please help... I'm trying to hide and epand rows in excel with a +/- button in a controlling row cell 1.... I've seen it done but don't know how to do it myself.

Thanks for your hel

John
 
J

john

Thanks Alf

I have seen another way... where the +/- button appears in the cell not in the left frame is this any different to grouping?
 
A

AlfD

Hi!

What you describe sounds like a button (sitting on a cell) which whe
clicked runs a VBA sub (macro).

A neat way with the button is (as well as making it fit a cell) t
toggle its Caption to + or - depending on its current state.

So far as the backup VBA is concerned, it depends on what you want t
achieve. But fundamentally you are likely to want to hide/unhide rows
The VBA instructions for that are EntireRow.Hidden or .Unhidden.

Are you familiar with VBA?

Al
 
Top