+ Reply to Thread
Results 1 to 5 of 5

Making Macro actions invisible

  1. #1
    Registered User
    Join Date
    11-26-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    4

    Question Making Macro actions invisible

    Hi,

    I am working on a relavantly huge excel file (5MB). I have 28 Macros in the file which are mostly long macros.

    When I run a macro, it quickly does the recorded actions, but since I am preparing this to be used by not expert users, I would like to skip the process of set of actions that are in the macro and just show them the result. In fact without them seeing all the actions, I need the macro to do the trick behind the scene and jump to the end and not show the users the changes that are happening.

    I tried to search for this option, but was not able to find any thing to resolve the issue.

    I was wondering of you guys can help in this regard.



    Thanks for your time and attention.
    Last edited by Ramin; 11-26-2009 at 02:17 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Macro

    Welcome to the forum.

    Please take a few minutes to read the forum rules, and then amend your thread title accordingly.


    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-26-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Making Macro actions invisible

    Hi, This is the first time that I am posting a thread in this website. Do you know how long does it usually take to get a reply?

    I have edited the title based on the forum rules. Does the title and my question make sense to you?


    Tnx
    Ramin

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Making Macro actions invisible

    Hi, at the start of the macro use

    Please Login or Register  to view this content.
    and at the end of the macro use

    Please Login or Register  to view this content.
    hth

  5. #5
    Registered User
    Join Date
    11-26-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Making Macro actions invisible

    Problem solved. You guys are amazing.

    I am really impressed.

    Thanks again
    Ramin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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