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?

Anna,
No, it will work on any computer that has it.
Use selfcert.exe which is (probably) installed on your computer.

NickHK

"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?

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?

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?

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?

I think you'll find SelfCert signatures can be used on any computer.

NickHK

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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?

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?

Hi,

The user has to install them in the computer and add-ins are not attached to
workbooks, you can use them whenever you want (as long as you have installed
them). An example of Add-In is the Solver.

Try to save a blank workbook as an add-in, just for having some example.
Excel will immediately change its extension from .xls to .xla and save it in
the add-ins folder. By the way, the name of the workbook is not the name of
the add-in. Instead, the name of the add-in is the "Title" of the file as
defined in the properties of the file. (Alt+F, i) if you have the book open
and (Alt+F, r) if you are in Windows Explorer.

Cya!

--
Carlos


"anna" wrote:

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?