Hi everyone,

I want to do thing like this: If A1=1, then hyperlink B2 and KP (where
kp is a Name Box that exist somewhere in the workbook), otherwise leave
B2 blank.

How can I do so?

Regards,
Mike