View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Theo van Daal Theo van Daal is offline
external usenet poster
 
Posts: 2
Default 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