I have created a macro and its working fine. But everytime
I open the Excel file, a pop up come and asked whether I
need to enable or disable the macro. Only when i
click "enable" it works. I want to bypass the pop up and
by default enable that macro everytime that Excel file is
opened.

Kindly assist pls.

For that you need to change the security to "Low" in Tools Macro
Security.
When it is medium, the pop-up comes, when it is high, the macro doesn'
work at all, and when it is low, the pop-up won't come.

- Manges

--
Message posted from http://www.ExcelForum.com

Hi,

First create a digital signature for yourself with SELFCERT.EXE (usually located in office directory).
then digitally sign your project from Tools|Digital Signature in VBA Editor.

Save your file, close an re-open it. On enable/disable pop-up message screen, you'll see a check box that says "Always trust to this source" (or could be similar to this. because I'm using non-english version). check this box and click enable macros.

next time when you open this file you'll not be asked.

kind regards.



--
Haldun Alay
"Sunil" , iletide sunu yazdi ...
I have created a macro and its working fine. But everytime
I open the Excel file, a pop up come and asked whether I
need to enable or disable the macro. Only when i
click "enable" it works. I want to bypass the pop up and
by default enable that macro everytime that Excel file is
opened.

Kindly assist pls.