How do I automatically hide columns in a worksheet based on a cell value?

I intend to set up an automated hide for a column (D) in sheet1 based on values of some cell in worksheet 2 (say cell B2).

Any suggestions?

Thanks you in advance.

Regards,

Deepak