VBA Signature

Im trying to sign some VBA code, and although my certificate in the certificate store says I can use it for code:-
When I try and use the signature in VBA through Access or Excel, I get the error:-
Any ideas what Im doing wrong, or how I need to sign the certificate properly?

Thank you
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

is your cert in pfx format?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Professor JMicrosoft Excel ExpertCommented:
you need to find the location of "Digital Certificate for VBA Projects"

usually it is located in inside Microsoft Office Tools. to access Microsoft Office Tools
the Click the Start button, point to All Programs, click Microsoft Office, click Microsoft Office Tools, and then click Digital Certificate for VBA Projects. In the Your certificate's name box

once you found Digital Certificate for VBA Projects

open it, and a small box will open. type a descriptive name for the certificate.  for example your name and click ok. see the screenshot below
then go back to VBE editor and there you will no loger see the error. click ok choose and you wil find your name as digital certificate. select it and click ok and thats it. to read more click here
tonelm54Author Commented:
That fixes it, thought the import was just an import, didnt matter what format it was in. But this worked. Thank you
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.