I don't understand - it seems like this problem just started, but I've been
using the same file on both my desktop and laptop computer for several
months. It does contain macros.

Last time I opened it on my desktop it told me that it couldn't verify the
digital signature and that because I changed the file, it was removing the
digital signature upon saving.

Frustrated, I thought I'd have to re-sign it. I launched the MS Tools
"Create Digital Certificate" app that came with MS Office 2003. But it
clearly says in that window that it will only certify a file for use on a
single computer.

Then how have I been using this file without problem for a few months!?

How can I get my Excel file to work on both my laptop and my desktop, with
macros, without paying extra money to buy a 3rd party cert?

Thanks for any help,
Colin

Colin,

No response yesterday, so I'll have a go. As far as I understand it having
run into this a few times

1. The certificate exists on the machine where it was created (I'm assuming
the desktop). Saving the file on that machine will be fine.
1b. Using the file on the other machine without trying to save it should be
fine. You should also be able to say that you trust content from this
publisher when any security warning is first issued about macros, etc.
2. The certificate does not exist in your personal store on the laptop.
Saving the file on the laptop will result in the certificate being removed,
hence the problems when you try and reload it on EITHER machine.

I have not tested this exhaustively, but there is an import/export function
in certmgr.msc that you should be able to use to export the certificate from
the desktop to the laptop. If this works, then you should be able to save
the code on the laptop.

On the desktop, Run certmgr.msc from the Start menu, Run command. Locate the
certificate under Personal. Right click, All Tasks, Export. Copy the
exported certificate file to the laptop.
On the laptop, Run certmgr.msc, select personal, right click, all tasks,
import. See if you can now save the file with the certificate on the laptop.

As I said, not fully tested.

Robin Hammond
www.enhanceddatasystems.com


"Colin Higbie" wrote in message
...
I don't understand - it seems like this problem just started, but I've been
using the same file on both my desktop and laptop computer for several
months. It does contain macros.

Last time I opened it on my desktop it told me that it couldn't verify the
digital signature and that because I changed the file, it was removing the
digital signature upon saving.

Frustrated, I thought I'd have to re-sign it. I launched the MS Tools
"Create Digital Certificate" app that came with MS Office 2003. But it
clearly says in that window that it will only certify a file for use on a
single computer.

Then how have I been using this file without problem for a few months!?

How can I get my Excel file to work on both my laptop and my desktop, with
macros, without paying extra money to buy a 3rd party cert?

Thanks for any help,
Colin

Thank you for the information.

- Colin


"Robin Hammond" wrote in message
...
Colin,

No response yesterday, so I'll have a go. As far as I understand it having
run into this a few times

1. The certificate exists on the machine where it was created (I'm
assuming the desktop). Saving the file on that machine will be fine.
1b. Using the file on the other machine without trying to save it should
be fine. You should also be able to say that you trust content from this
publisher when any security warning is first issued about macros, etc.
2. The certificate does not exist in your personal store on the laptop.
Saving the file on the laptop will result in the certificate being
removed, hence the problems when you try and reload it on EITHER machine.

I have not tested this exhaustively, but there is an import/export
function in certmgr.msc that you should be able to use to export the
certificate from the desktop to the laptop. If this works, then you should
be able to save the code on the laptop.

On the desktop, Run certmgr.msc from the Start menu, Run command. Locate
the certificate under Personal. Right click, All Tasks, Export. Copy the
exported certificate file to the laptop.
On the laptop, Run certmgr.msc, select personal, right click, all tasks,
import. See if you can now save the file with the certificate on the
laptop.

As I said, not fully tested.

Robin Hammond
www.enhanceddatasystems.com


"Colin Higbie" wrote in message
...
I don't understand - it seems like this problem just started, but I've
been using the same file on both my desktop and laptop computer for
several months. It does contain macros.

Last time I opened it on my desktop it told me that it couldn't verify
the digital signature and that because I changed the file, it was
removing the digital signature upon saving.

Frustrated, I thought I'd have to re-sign it. I launched the MS Tools
"Create Digital Certificate" app that came with MS Office 2003. But it
clearly says in that window that it will only certify a file for use on a
single computer.

Then how have I been using this file without problem for a few months!?

How can I get my Excel file to work on both my laptop and my desktop,
with macros, without paying extra money to buy a 3rd party cert?

Thanks for any help,
Colin