Excel slow after vba

[lucyvba]

Hello, I searched for answers but found nothing and this is driving me crazy

I'm making an Workbook to help my workmates to get some info faster from our db

One of my macros is just to change from an worksheet to another worksheet and after I execute it, excel becomes very slow and I can't nearly do anything other than close it and open again. I have larger vba codes and they don't make excel lags like this after I execute them, I wonder what could be causing this

Here my code that makes excel unusable after execution:

    Worksheets("SCC_Status").Visible = True
    Sheets("SCC_Status").Select
    Worksheets("Inicio").Visible = False

Thanks in advance

 

[Sunjinsak]

Hi lucyvba, and welcome.

On it's own that code shouldn't cause Excel to become unresponsive. Is that just a smaller code snippet from a larger routine? If so can you post the rest of the code?

Is there a lot of data in either/both of the Worksheets?

You can try changing the line

Sheets("SCC_Status").Select

to

Sheets("SCC_Status").Activate

instead, but that shouldn't really make a difference here.

 

[lucyvba]

My code was indeed only these lines.

But your change really saved my Worksheet, OMG!

I changed it to .Activate and now is working totally fine. I even changed it back to .Select and it lagged again. I couldn't never think of this because I have lots of other codes with Sheets("...").Select and they don't lag my excel after executing, I wonder why...

Thank you very much, I still can't believe it's solved

 

[Sunjinsak]

You're welcome . Thanks for the feedback.

It's generally a bad idea to select anything in code unless you really need to. For reference the following link explains it pretty well...
Difference Between Select and Activate Methods in VBA - Excel Campus

Though I'm not sure why you saw such a performance hit selecting just one sheet. Still, glad you got it fixed.