Screen updating and enable events code

This was code from https://www.rondebruin.nl/win/s1/outlook/amail4.htm

If the code:

Please Login or Register  to view this content.

if it will be removed, what will happen? What is the use of this codes in mailing?

As this is setting both to True I'd guess it was near the end of the code? It's returning settings to their normal state after they were changed to False earlier in the code.

Removing it purely stop the two settings being set to True until you close Excel and open it again, or set them to true elsewhere.

Nothing like sheet change events will fire and any code that makes changes that would be visible on screen will not be seen.

Beth.

Yes, it is at the end of the code. In the start:

Please Login or Register  to view this content.

Why it is set to false in the start of the code?

Originally Posted by dummy777

Why it is set to false in the start of the code?

Setting ScreenUpdating to False stops the screen showing what's going on as the code runs. Sometimes this is because you don't want to see people what's happening but mostly it's used because code runs quicker when Excel isn't constantly redrawing the screen at every little change.

Setting EnableEvents to False stops events from firing as your code runs. If you have a change event, for example, that fires when you change the value in A1 but the code will change A1 and you do not want that event to fire, then setting EnableEvents to False will prevent it happening. Not easy to explain, but I'm sure there is plenty of info out there that will give you more of an idea on why you would ever use is.

Beth.

Oh I see, thank you for explaining.

No problem. Happy I could help.

Beth.