View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Anna Anna is offline
external usenet poster
 
Posts: 132
Default Macros & Digital Signatures

Hmmm... well, I created an add-in and now I get an error that it is not a
valid add-in. Will have to do some more research on this, I suppose!

Once I have it working, will the add-in just be permanently attached to the
workbook or will the users have to add it? Just thinking outloud really -
I'll do some reading on Microsoft's page.

Thanks.

"Gord Dibben" wrote:

Anna

Self-cert signatures from the MS Office Tools can be used only on the computer
on which it is created.

To create an add-in you just open the workbook with the macros and FileSave
AsFile Type Add-in(*.xla) which is found waaaaay down at the bottom of the
list.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 20:41:01 -0700, anna wrote:

Thanks Robin & Nick!

Robin - not sure how to make the project an add-in, but I will definitely
look into it!

"Robin Hammond" wrote:

Anna,

This may not work for you, but...

You can create a signature using selfcert.exe. If you make your project an
add-in, then users will not be prompted to enable macros unless they have
security set to very high.

--
Robin Hammond
www.enhanceddatasystems.com


"anna" wrote in message
...
Just a question about digital sigs -

I do not have a digital signature, but I've seen some information on
creating my own. If I did create my own signature, could I email this
signature to everyone who would want to use the spreadsheet? Or will the
sig
only work on my computer?