How do I use ActiveX controls to hide/show rows on a sheet?

I am trying to create a spreadsheet that uses ActiveX controls to allow for
rows of text to be displayed or hidden. I am using radio buttons and
checkboxes to determine which rows I would like displayed.

Is this possible?

Hello activeXhelpPlease,

A better approach would be to create a User Form that you can display using a hot key combination. This will significantly reduce memory resources, speed execution, and allow you to do more. If you haven't created a User Form using VBA, I will be glad to help out. You can contact me by email LeithRoss@aol.com if you want to discuss this more in depth.

Sincerely,
Leith Ross

Have you looked at group and outline under the data menu?

It may do all that you want.

Another thought would be Filter under the Data menu.

--
regards,
Tom Ogilvy

"activeXhelpPlease" <activeXhelpPlease@discussions.microsoft.com> wrote in
message news:C11DC36A-E59B-4856-9C7B-2E3D61DB9CD6@microsoft.com...
> I am trying to create a spreadsheet that uses ActiveX controls to allow
for
> rows of text to be displayed or hidden. I am using radio buttons and
> checkboxes to determine which rows I would like displayed.
>
> Is this possible?