ScreenUpdating = False not working

[JumboCactuar]

Hi,
macro is set up as below

Sub Start Macro()
application.screenupdating = false
call macro2
application.screenupdating = true
End Sub

Now usually it works fine but the macro im working with does calculations on 30000 ish rows (takes around 90 seconds) and causes Excel to display "Not Responding" for a short time and i see some of the calculations happening.

Anyone experienced this? And is there anything i can add to application.screenupdating to make sure the window doesnt change at all while the macro is running?

Thanks in advance

 

[MARK858]

Care to post the code in macro2?

 

[xyga1998]

can you check macro2 if it has application.screenupdating = true inside its code?

 

[JumboCactuar]

Figured it guys
When calling another procedure (macro2) it seemed to turn it back to true

So added false to top of macro2 and it's done the trick

Thanks for the help

 

[Joe4]

When calling another procedure (macro2) it seemed to turn it back to true

Odd, I tested it out, and it didn't do that for me. Cannot figure out why it would do that until there was something in "macro2" explicitly turning it on...

 

[MARK858]

And I agree it shouldn't exhibit that behaviour. Again post your code

 

[Joe4]

Here is my simple test to show that calling another macro should not change that value (unless that other macro explicitly changes the value):

Sub Test()
    Application.ScreenUpdating = False
    Call Macro2
    Application.ScreenUpdating = True
End Sub

Sub Macro2()
    MsgBox "ScreenUpdating currently set to: " & Application.ScreenUpdating
End Sub