Apple

tell application "Microsoft Excel"

activate

make new hyperlink of active cell at active sheet with properties {address:"Sheet2!A1"}

end tell

This executes. The problem is that when you click on the hyperlink there is an error. Looking at the link. It's missing the "#" in the field

Objective is to get the field (command+K) to display #Sheet2!A1". The code above doesn't work.

Changing this address:"Sheet2!A1" to address:"#Sheet2!A1" gets "#Sheet2!A1#Sheet2!A1" in the field.

So how do I get the link to field to display #Sheet2!A1?

Any help would be appreciated.