View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jenhu jenhu is offline
external usenet poster
 
Posts: 1
Default How to stop message popping up before open the excel?


Hi,

I have to add "Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.Saved = True
End Sub"

in the excel macros editor. After I added it, it will keep prompting
the message to users:
"The document you are opening contains macros. Some macros may contain
harmful viruses. If you are sure this document is from a trusted source,
click Yes. If you are not sure and want to prevent any macros from
running, click No."

How to stop this message coming up permanently?

Thank you.


--
jenhu
------------------------------------------------------------------------
jenhu's Profile: http://www.excelforum.com/member.php...o&userid=28969
View this thread: http://www.excelforum.com/showthread...hreadid=567578