Hiding a row (Including tick boxes)

[leelee23]

Hi all,

I have a problem! I have an Excel spreadsheet that is reached through criteria selected on a previous sheet. Within the macro, one of the functions is an if statement to hide the row if such a criteria is met, and that's fine, I've done that.

The problem comes because there is a tick box in each cell of that row. Please can someone suggest some coding to hide all tick boxes within row 28?

That would be very much appreciated!

Thanks,

Lee

[Leith Ross]

Hello Lee,

This macro will hide all Checkboxes in the row you give it.

Please Login or Register  to view this content.

Calling Example:
HideCheckBoxesInRow 28


Sincerely,
Leith Ross