Making Macro actions invisible

[Ramin]

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.

[shg]

Welcome to the forum.

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


Thanks.

[Ramin]

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

[teylyn]

Hi, at the start of the macro use

Application.ScreenUpdating = False

and at the end of the macro use

Application.ScreenUpdating = True

hth

[Ramin]

Problem solved. You guys are amazing.

I am really impressed.

Thanks again
Ramin