A worksheet is unexpectedly activated

[mumps]

I have a macro assigned to a button that runs perfectly on the data in the active sheet and in other sheets as well using Excel 2010. However, when I try to run it using Excel 2013 or Excel 2016, a different sheet is unexpectedly activated so the macro generates an error. There is nothing in the code that activates this other sheet and, to be safe, the macro disables events, even though there is nothing in the event code that even references to this other sheet. I have tried assigning the active sheet name to a variable at the beginning of the macro and the using that variable to activate the sheet even though it is already the active sheet, but the other sheet is still activated. I was wondering if anyone else has experienced this problem. I was hoping to get some feedback on what could possibly cause this to happen. As I already mentioned, it runs without errors using Excel 2010. My suspicion is that there is a glitch in the 2013 and 2016 versions of Excel. I haven't posted the code because it is quite long and part of a large project that calculates the final results of a cross country meet. If anyone has any suggestions or would like the code to be posted, I can certainly do that. Many thanks in advance.

Also posted at: A worksheet is unexpectedly activated

 

[mumps]

@RoryA
Thank you for your suggestion. I had tried setting a worksheet variable to the activesheet at the start of the code, but unfortunately, the problem persisted. I agree that it's probably a bug. I'm exploring a way of modifying the code to see what else might work to perform the same tasks.

@Alex Blakenburg
That is correct, there is no line in the code that activates any other sheet. I'm trying to determine why this is happening so that it can be avoided.

 

[RoryA]

Did you use it to reactivate the sheet after unprotecting? Most of your code uses unqualified range references which you should fix ideally

 

[mumps]

Yes, I reactivated the sheet after unprotecting. When I tried setting a worksheet variable to the activesheet at the start of the code, I used the variable to qualify the range references using dot notation. It still didn't work.

 

[RoryA]

Curious. It worked fine for me in 2016 with those changes. If the ranges are properly qualified, I don’t see how it could fail.

 

[mumps]

Could you post the changes that worked for you?

 

[RoryA]

I did the lazy way:

Sub RaceResults()
    With Application
        .ScreenUpdating = False
        .Cursor = xlWait
        .EnableEvents = False
    End With

    Dim sourceSheet As Worksheet
    Set sourceSheet = ActiveSheet

    Sheets("FinalStandings").Unprotect Password:="iwbi48crci"
    Sheets("RegionQualifiers").Unprotect Password:="iwbi48crci"

    sourceSheet.Unprotect Password:="iwbi48crci"    
    sourceSheet.Activate
    Dim bottomC As Long
    'Deletes blank rows.
' rest of code

 

[mumps]

The code works now without errors using Excel 2013. Thank you so much, Rory, for your expertise, time and patience. You have saved many people including myself, many headaches.

 

[RoryA]

Glad we could help.