View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
papou[_9_] papou[_9_] is offline
external usenet poster
 
Posts: 52
Default Macro virus prompt

Hi Michael
Execute SELFCERT.EXE which you should find in Program Files\Microsoft
Office\Office
Fill in the name of your certificate
Open your workbook next and in the VBE see Tools, Digital signature (please
note option may vary since I own a French version)
Then choose your new certicate, validate and save and then close your
workbook.
Open your workbook again, a different warning message will appear, tick
checkbox "Always trust..."
Next time your workbook will open there will be no warnings anymore.

HTH
Cordially
Pascal


"Michael" a écrit dans le message de
...
I want to run a macro daily from a windows Scheduled Task
which works fine, however when the file opens I get the
warning message asking if I want to enable Macro's. I
read somewhere that you can digitally sign the macro and
the message box will not appear, how do I do this.

Thanks in advance
Michael