Someone wanted a copy of a spreadsheet of mine, so I sent it to him.
It uses VB functions I wrote, and he didn't get the calculations. I
figure he could get it to work with SELFCERT.EXE, but I'd like some
good directions that I could put in my spreadsheet to tell someone how
to check out my spreadsheet for safety and then enable it. (Or
assume I'm safe then enable it).


--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison

Selfcert signatures are good only on the computer on which they are created.

You cannot export the key to another.

Which version of Excel are you both running?

Perhaps his security settings are too high?

He should be able to add you to his list of Trusted Publishers.


Gord Dibben MS Excel MVP

On Wed, 20 Jan 2010 11:59:54 -0700, Howard Brazee wrote:

Someone wanted a copy of a spreadsheet of mine, so I sent it to him.
It uses VB functions I wrote, and he didn't get the calculations. I
figure he could get it to work with SELFCERT.EXE, but I'd like some
good directions that I could put in my spreadsheet to tell someone how
to check out my spreadsheet for safety and then enable it. (Or
assume I'm safe then enable it).

On Wed, 20 Jan 2010 13:09:28 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

Selfcert signatures are good only on the computer on which they are created.

You cannot export the key to another.

Which version of Excel are you both running?

Perhaps his security settings are too high?

He should be able to add you to his list of Trusted Publishers.

I don't know which version he's at. I sent him both an .xlsm version
and an .xls version that I created by hitting the circle on the top
left (whatever it's called), then save as, then Excel 97-2003
workbook.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison