How to tone down excel?

[McQuinge]

Hi!
I was reading a thread about userforms when I stumbled over this test file.
http://www.condisco.co.uk/pdf/Norie.xls

When I activate the userform in this workbook the entire excel window was toned down (just like the UAC function in Windows) and then the userform came up.

Can someone tell me the secret how to make this happen?

Regards
McQuinge

 

[Smitty]

It looks like it's using WIndows API calls to set a transparent user form, when the user entry form is called.