Eliminate need for "Enable Macro" selection

Status
Not open for further replies.
C

cte67

I created a macro. At first it did not work after restarting Outlook 2007.

Under Macro Security, I set "Warnings for all Macros". Then the macro

worked after restarting.

However, when I run the macro for the first time, I get the message,

"Microsoft Office has identified a potential security concern ...." I choose

the "Enable Macros" button.

I did run SelfCert.exe ... gave it the name Macros. No difference ... still

asks about enabling macros after I restart Outlook.
 
K

Ken Slovak - [MVP - Outlook]

If you have security set to always prompt that's what you get even with a

signed VBA project.

After creating the certificate did you sign your VBA project with it? You do

that from the Tools, Digital Signature menu entry in the VBA project's

menus. Then you set your security to High, exit and restart Outlook and you

shouldn't get that prompt.

"cte67" <cte67> wrote in message

news:95394241-1E5B-4D44-999C-7259ABDE5238@microsoft.com...
> I created a macro. At first it did not work after restarting Outlook 2007.

> Under Macro Security, I set "Warnings for all Macros". Then the macro
> worked after restarting.

> However, when I run the macro for the first time, I get the message,
> "Microsoft Office has identified a potential security concern ...." I
> choose
> the "Enable Macros" button.

> I did run SelfCert.exe ... gave it the name Macros. No difference ...
> still
> asks about enabling macros after I restart Outlook.
>
 
C

cte67

Thanks for the info! Where do I set security to High?
wrote:
> If you have security set to always prompt that's what you get even with a
> signed VBA project.

> After creating the certificate did you sign your VBA project with it? You do
> that from the Tools, Digital Signature menu entry in the VBA project's
> menus. Then you set your security to High, exit and restart Outlook and you
> shouldn't get that prompt.
 
K

Ken Slovak - [MVP - Outlook]

Tools, Macro, Security.

"cte67" <cte67> wrote in message

news:8005A141-EC95-453C-A798-5E41F72B4A65@microsoft.com...
> Thanks for the info! Where do I set security to High?
 
C

cte67

I should have been clearer. I had looked there ... did not see any option

for setting security to high. I'm running Outlook 2007.
wrote:


> Tools, Macro, Security.
 
K

Ken Slovak - [MVP - Outlook]

Did you look in the Tools menu of the Outlook Explorer (folder view)? It's

right there. Tools, Macro, Security. You can get to the same spot by using

the Trust Center and going to the Macro Security tab.

"cte67" <cte67> wrote in message

news:35D3075C-3F1F-4190-81BD-8327CEA1F327@microsoft.com...
> I should have been clearer. I had looked there ... did not see any option
> for setting security to high. I'm running Outlook 2007.
 
C

cte67

I had checked there. Don't see any option for setting security to High.
wrote:


> Did you look in the Tools menu of the Outlook Explorer (folder view)? It's
> right there. Tools, Macro, Security. You can get to the same spot by using
> the Trust Center and going to the Macro Security tab.
 
K

Ken Slovak - [MVP - Outlook]

In 2007 that option is called "Warnings for signed macros; all unsigned

macros are disabled". Unfortunately it doesn't disable the warnings. The way

to do that is to have no security check which is dangerous.

"cte67" <cte67> wrote in message

news:236689B2-B32C-4840-8217-EA04AF79E725@microsoft.com...
> I had checked there. Don't see any option for setting security to High.

> " - " wrote:
>
> > Did you look in the Tools menu of the Outlook Explorer (folder view)?
> > It's
> > right there. Tools, Macro, Security. You can get to the same spot by
> > using
> > the Trust Center and going to the Macro Security tab.

>
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
N Eliminate the +1 before all numbers Using Outlook 1
M Eliminate bug that closes my Outlook Using Outlook 3
M Eliminate trail verson of MSOutlook and go back to my original Outlook Express. Using Outlook 2
S How do I eliminate multiple in boxes? Using Outlook 3
D Trying to eliminate incoming email from being put into 'Large Mail' folder, even if it means editing registry to do so. Using Outlook 5
R how do I eliminate allow access dialog box using VBAproject in Out Outlook VBA and Custom Forms 1
K How do I eliminate the "Enable Macro" selection? Outlook VBA and Custom Forms 16
J Moved many emails to Outlook external folder, need to delete on Gmail server Using Outlook 13
A Wishlist Arthur workman I need the community's assistance thank you Using Outlook 3
A from Arthur to anyone I need your expertise assistance Using Outlook.com accounts in Outlook 7
Marc2019 Need help please! Cannot Setup my outlook email account on my Mac Outlook 2011 Using Outlook.com accounts in Outlook 2
T Need to backup outlook.com to cloud storage, without desktop software - Testing UpSafe. Are there any similar services? Using Outlook.com accounts in Outlook 8
C need help setting up outlook first time Using Outlook 1
N Need help syncing contacts to iPhone X Using Outlook 8
L Need to import multiple Outlook files to Office 365 Account Using Outlook 4
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
S Error using AddressEntry.GetContact - need help Outlook VBA and Custom Forms 2
EaglePI Outlook 2010 need help with rules Using Outlook 0
Horsepower Need iCloud mail only Using Outlook 1
O Don't need any add-ins at all? Using Outlook 2
B Need Help - Willing to pay Outlook VBA and Custom Forms 10
A Need to view Outlook calendar in Sharepoint .. Using Outlook 2
J Need Help with Contacts VBA Outlook VBA and Custom Forms 1
L Accidentally merged a calendar with .ics, need to undo! Using Outlook 1
H Need help setting up GetFolderPath-Makro with Vodafone IMAP Mail-Account Outlook VBA and Custom Forms 0
D Need Genuine Office or Outlook 2007 Using Outlook 3
G how to cancel a recurring meeting but not the organizer but all attendees need to know. Using Outlook 1
H I need a developer to customize an Outlook Contact form Outlook VBA and Custom Forms 0
T Need help with finding/updating task Outlook VBA and Custom Forms 1
N Need a case sensitive rule Outlook VBA and Custom Forms 1
C Need rule to alert when an email has not been replied to within 24 hours Using Outlook 1
P Outlook 2003 - Do I need a new profile? Using Outlook 2
F Outbox - Multiple Emails need to be manually opened? Using Outlook 5
Miquela I need to make a calendar to share here at work with 40 other people Using Outlook 1
S Need CC: to show the original To: recip[ients Using Outlook 4
Denis Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>> Using Outlook 1
D Need to extract a line from a word attachment, and add it to the subject line Outlook VBA and Custom Forms 3
Mary B VBscript: Need to copy every email to a folder & mark that copy as read Outlook VBA and Custom Forms 5
mikecox Desperat; need hands on support Using Outlook 1
E Need Help on Setting up a repeated Reminder on Task with Reoccurence Every Year Using Outlook 6
Glyn Do I Need Outlook.com Using Outlook 1
B Need Help Creating Email Based on Subject w Address in Body Outlook VBA and Custom Forms 1
G Need help configuring a PRF for Outlook 2010 and 2013 Using Outlook 0
K Excel Import Option: Need Help Updating Existing Records BCM (Business Contact Manager) 0
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
Stig Arvidsson Need a Script for handling moved mail from inbox Using Outlook 3
C Outlook 2010, Need to restrict domain users from installing any sort of a addin in outlook Using Outlook 2
J Need help with installation of BCM in Outlook2013 BCM (Business Contact Manager) 5
F Outlook 2010 - Need help with a custom field. Using Outlook 3
Similar threads


















































Top