Big Dick Kusleika over at Daily Does of Excel made some suggestions for Excel 12. One of which was to have captionless worksheets.
The following example sort of does it, it’s a modification of Steven Bullen’s and Tim Clem’s Form fun class.
I didn’t spend very long on this as it’s not really of any use to me, I just wondered if it could be done. To use it in anger you’d have to tightly control the windows index and there protection settings I’d guess. And what about adding transparency?
Related posts:
Nice!
I don’t get it.
[...] Why on earth would you want to do it I hear you ask! That’s a very good question! When I started this I thought it was really not very useful at all. I’m still thinking that, but maybe there might be a few practical uses for it. I’m thinking tool tips and popup type things. I have covered using captionless user forms (and worksheets!), and even popup forms previously. I was never happy with the way the captionless forms looked in VBA, it’s ok in VB6 but in VBA they has a wafty boarder. [...]