Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to stop message popping up before open the excel?

Either set your Macro Security level to Low, which is not recommended or get a
digital certificate/signature and sign the project.

If just for your own computer, Microsoft Office Tools has a SelfCert function.

You can create a signature to use on your own computer only.


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 14:37:28 -0400, jenhu
wrote:


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.


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


Thank you, that's exactly what I need.


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Howdo I stop the pop-up 'Euro Value' appearing when I open Excel? brendan02 Excel Discussion (Misc queries) 3 April 10th 06 04:20 PM
Error message when using Excel to open text file orutulsa Excel Discussion (Misc queries) 2 March 14th 06 07:10 PM
when i open a file a new excel window opens. how do stop this susan Excel Discussion (Misc queries) 1 July 1st 05 03:08 PM
Stop excel emedding (opeing in mail format) when outlook is open. Help Hey New Users to Excel 1 April 26th 05 02:29 PM
Cannot open Excel attachment from e-mail when Excel is already ope John P. Excel Discussion (Misc queries) 1 March 1st 05 09:35 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"