Dimming Background

Question

Sometime ago I saw code to dim everything in the background while user form is displayed.

It gives Excel same effect as is quite common now in HTML.

Could anyone help in pointing to this code?

Answer 1

You are EXTREMELY patient!

Thanks for the update!

Answer 2

Three years later, here is the answer:

Good old J-Walk to the rescue.

http://spreadsheetpage.com/index.php/file/light\_box\_demo/

Answer 3

One possible approach is to place a semi-transparent Picture on the worksheet that covers all the cells of interest.

At start, have the Picture be not Visible.  Then have your code first make the Picture Visible and then display the form.