Sending a macro-enabled spreadsheet

H

Howard Brazee

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
 
G

Gord Dibben

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
 
H

Howard Brazee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programming question 5
Copying a row to another spreadsheet 1
Lost horizontal scroll bar 0
VB macros in new Excel 24
Ignore error 3
Need Help with Macro Security 1
Months between two dates 5
Names 5

Top