I have VB6 and VB.NET on my PC, however, when i create a macro from within Excel its defaulting to using VB6. Anyone know how I can force it to use VB.NET.

any comments appreciated, thinking perhaps its a registry change or something ....

Cheers
John