Disable the Macro Pop up

S

Sunil

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.
 
M

mangesh_yadav

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
 
H

Haldun Alay

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" <[email protected]>, 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.
 
Top