macro to hide then show cells

aiqtadar · Jan 26, 2007

http://i86.photobucket.com/albums/k96/georgeforemans/ss.jpg

i want to make it so that cells 23-28 (columns A-h) are hidden and when
you click the blue button, it shows then hides the results according to
when it's hidden at the start or not.

could somebody make me a macro that would do this? or direct me to a
website that may help?

many thanks...

Mike Rogers · Jan 26, 2007

aiqtadar

It may be easier to just hide & unhide the column with your answers. Goto
Tools>Macros>record new macro. Now Hide the column, (ie. column D) and stop
the recorder. Do the same thing to unhide the column. Now assign each macro
ro a button to either hide or undie you data.

Mike Rogers

Gord Dibben · Jan 26, 2007

You mention hiding A23:H28

You can only hide entire rows or columns, not ranges of cells within those rows
and columns.

Gord Dibben MS Excel MVP