how to use hyperlink in VBA command button

[zaska]

Hi,

i have the hyperlink "=HYPERLINK("D:\tEST\"&A1&".xls","CANON")

i wish to have a command button instead of hyperlink for this.

Can anyone help me?

THanks