+ Reply to Thread
Results 1 to 8 of 8

Application.Run "Macro"

  1. #1
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Application.Run "Macro"

    Hi, is there an equivalent to Application.Run in Outlook?

    Sorry and also Application.ScreenUpdating doesn't seem to work in Outlook.
    Last edited by lb_33; 03-04-2022 at 12:33 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,276

    Re: Application.Run "Macro"

    No there is no equivalent. Why do you need Run? And what are you doing in Outlook that requires screenupdating to be turned off?
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Application.Run "Macro"

    Thanks for advising.
    I need Application.Run so that macros don't show.
    The screen update off, I haven't got to that part yet, but would be to save multiple emails to a folder. It may or may not be needed.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,276

    Re: Application.Run "Macro"

    I can't see why that would require turning the screen off.

    I don't follow your comment about Application.Run, I'm afraid.

  5. #5
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Application.Run "Macro"

    That's a bonus for the screen update.
    With the Application.Run, I was used to using Application.Run "Macro" in Excel and it wouldn't show in the list when clicking macros.
    So another user only has one macro to run.

    see.png

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,276

    Re: Application.Run "Macro"

    There is no need for Run for that. If the routines are all in the same module, just make the ones you don't want visible in the macros list Private. Alternatively, put Option Private Module at the top of the module with the routines you don't want visible, then you can still call them directly from other modules.

  7. #7
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Application.Run "Macro"

    Yes, they were in another module.
    Private Module did work for this.
    Thanks for the tip.

  8. #8
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,276

    Re: Application.Run "Macro"

    You're welcome and thanks for the rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem with consistent "Application.Wait (Now + TimeValue("0:00:10"))"
    By JimmyWilliams in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 02-09-2018, 08:20 PM
  2. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  3. Replies: 1
    Last Post: 05-23-2013, 02:04 PM
  4. Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" not working
    By redders in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2011, 03:52 PM
  5. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  6. Replies: 15
    Last Post: 12-09-2009, 08:46 AM
  7. Macro debugs at "Application.CountA" with 45.000+ rows
    By Kjaer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2007, 05:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1