I'm trying to figure out how to generate my own Software Publisher Certificate using Certificate Services on my own Windows 2003 server. Can anyone help guide me through this?

This one appears to be a toughie. Being a fully paid up MSDN universal subscriber I originaly posted the question in a 'managed' MSDN news group.

I got one reply from MS telling me to "Just enroll for a 'code signing' certificate using that template." If I was standing in front of the guy I would have slapped him.

My goal is to generate spc and pvk files that I can then go and sign my own macro code.

The background is:
I'm the single developer in a small office. I write a lot of .net code used with Excel and I need to get rid of the annoying "Enable Macros" buttons from our own code.

I know I could purchase an SPC from verisign, etc but this seems pointless for my situation as the only people that will be using this code is ourselves and we trust ourselves.

Anyone done this before?

Anyone needing a good laugh at the offical reply from Microsoft can look here
http://msdn.microsoft.com/newsgroups/managed/default.aspx?pg=2&lang=en&cr=US&guid=&dg=microsoft.public.platformsdk.security&fltr=

thread posted on 15th July, subject: Generating my own Software Publishing Certificate