<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>'Custom Appointment Macro locks rest of Outlook when run' Thread RSS Feed</title>
    <link>http://www.programmersheaven.com/</link>
    <description>Contains the latest posts from the thread 'Custom Appointment Macro locks rest of Outlook when run' posted on the 'VBA' forum at Programmer's Heaven.</description>
    <language>en</language>
    <copyright>Copyright 2012 Programmers Heaven</copyright>
    <pubDate>Thu, 24 May 2012 01:06:49 -0700</pubDate>
    <lastBuildDate>Thu, 24 May 2012 01:06:49 -0700</lastBuildDate>
    <generator>Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic</generator>
    <docs>http://www.rssboard.org/rss-specification</docs>
    <ttl>360</ttl>
    <image>
      <url>http://www.programmersheaven.com/images/ph.gif</url>
      <title>Programmers Heaven</title>
      <link>http://www.programmersheaven.com/</link>
      <width>88</width>
      <height>31</height>
    </image>
    <item>
      <title>Custom Appointment Macro locks rest of Outlook when run</title>
      <link>http://www.programmersheaven.com/mb/vba/410508/410508/custom-appointment-macro-locks-rest-of-outlook-when-run/</link>
      <description>I've created a basic macro and assigned it to a toolbar button. The macro opens the new calendar appointment window with a default template (I know there are other ways to do this via personal and organizational templates etc. but for a handful of users with limited access rights this is the way we want to go). The problem is that when the macro is activated the appointment window stays on top and locks out everything else in outlook  - so users cannot refer to other emails or calendar entries (which they need to do) unless the new appointment window is closed:&lt;br /&gt;
&lt;br /&gt;
Sub Engineers_Template()&lt;br /&gt;
&lt;br /&gt;
   &lt;br /&gt;
    Dim oApp As Outlook.Application&lt;br /&gt;
    Dim oMsg As Outlook.AppointmentItem&lt;br /&gt;
    &lt;br /&gt;
&lt;br /&gt;
    Set oApp = New Outlook.Application&lt;br /&gt;
    &lt;br /&gt;
    Set oMsg = oApp.CreateItemFromTemplate("H:\Install Team Job Template - TEST\Install Team - New Job Details.oft")&lt;br /&gt;
    &lt;br /&gt;
    If Not oMsg Is Nothing Then&lt;br /&gt;
        oMsg.Display vbModal&lt;br /&gt;
    Else&lt;br /&gt;
      MsgBox "Template Not Found. Contact I.T team"&lt;br /&gt;
    End If&lt;br /&gt;
        &lt;br /&gt;
End Sub&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
  &lt;br /&gt;
Any ideas on how I make it so the rest of outlook isn't locked when the macro is running?&lt;br /&gt;
Thanks&lt;br /&gt;
&lt;br /&gt;</description>
      <guid isPermaLink="true">http://www.programmersheaven.com/mb/vba/410508/410508/custom-appointment-macro-locks-rest-of-outlook-when-run/</guid>
      <pubDate>Tue, 08 Dec 2009 09:39:10 -0700</pubDate>
      <category>VBA</category>
    </item>
  </channel>
</rss>
