If the box is only one cell in size, maybe you could assign a macro that
selects the cell below it.

--
Regards,
Tom Ogilvy


"geebee" wrote:

hi,

I have some rectangle autoshapes in my spreadsheet that are transparent.
Although it looks cool, users cannot click on the cells behind it, so I have
been requested to get rid of the transparent autoshapes. Can anyone ell me
how to still have these transparent boxes in front of the cells while still
allowing the user to click on the cells?

Thanks in advance,
geebee