[SOLVED] VBA Application.EnableEvents and Application.ScreenUpdating

Situation: I have many sheets in my workbook and I need to change all of the reference cell value when I change the main cell value.

Problem: I have a minor problem in my EXCEL, when I run this code my excel stop 3~5 secs. Can someone define the problem? Why it stop 5secs?

Do this problem can deal with the Application.EnableEvent / Application.ScreenUpdating?
*I don't know where I will put it.

This is my code:

Please Login or Register  to view this content.

Thank you for your help where I will put the application.ScreenUpdating. But still it stop 3~5 secs Does my code have an error or do my code is too hard and long to perform?

Why I want to resolve about this issue (hangs 3~5 secs), because someone will use this code and they will taught why it hangs like that...... bla bla.

Why turn the table headers off and on inside the loop? Also, if you are running 2013, turning sheet protection on and off is much slower.

How many sheets is a lot?

ajryan - I don't know why it happened. I only got 52 sheets that will change the value. My working station is good.

Rory - Because some of my sheets have a formula that is why I protect it for other code process. Like importing/embedded another sheet.... 52 sheets need to change the header.

I don't know if I make myself more complicated doing my work. There is a formula on each table and it was refer to each other that is why I turn on and off the header.

There is an issue about "header" of the table style that they cannot copy the "date" format same as they are referring with.

See the attachment below:

Sample.xlsb

P.S. Sorry for my grammar.

There's no need to do one cell at a time - try this:

Please Login or Register  to view this content.