ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   File opens slow with digital signature (https://www.excelbanter.com/excel-programming/428258-file-opens-slow-digital-signature.html)

Theo van Daal

File opens slow with digital signature
 
Hello experts,

In the office we have a lot of files with some event macros in them that
give more or less rights to the current user of the file. The files are on a
server in a local network.
To not be prompted whether to enable or disable macros each time these files
are opened, I created a self signed certificate and attached it to these
files and it works fine.
However, when I open the files myself, they open quite quickly (a few
seconds), but when one of my colleagues opens them, they open quite slow
(about 30 seconds).
When I remove the digital signature it opens quickly too when a colleague
opens the file.
Is there an explanation for this and furthermore can this be solved in a way
that opening by collegagues goes faster too?

Thanks in advance

Theo



Theo van Daal

File opens slow with digital signature
 
Hi,
Finaly found it myself. Adding my self made certificate to the Trusted Root
Authorities store on every PC of the concerned colleagues did the trick.
Now on their PC the files open quite quickly too.
Kind regards,
Theo


"Theo van Daal" schreef in bericht
...
Hello experts,

In the office we have a lot of files with some event macros in them that
give more or less rights to the current user of the file. The files are on
a server in a local network.
To not be prompted whether to enable or disable macros each time these
files are opened, I created a self signed certificate and attached it to
these files and it works fine.
However, when I open the files myself, they open quite quickly (a few
seconds), but when one of my colleagues opens them, they open quite slow
(about 30 seconds).
When I remove the digital signature it opens quickly too when a colleague
opens the file.
Is there an explanation for this and furthermore can this be solved in a
way that opening by collegagues goes faster too?

Thanks in advance

Theo






All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com