In my workbook, I have VBA code on a worksheet that includes some spin buttons that increment or decrement a cell's value. Most of the time these spin buttons work as expected without any problems. I also have some code that is looking to see if a specific cell within a range has changed its value and then run some code if it does. And, this is working as expected.
I have come across a problem that I cannot explain.
For some reason, when I execute the spin button, the active sheet changes. This happens only occasionally. I do not have any code to either select or activate that sheet, it just happens and not all the time. I have been trying to debug this by inserting into the various macros "msgbox activesheet.name" just to see what the current name of the active sheet ... and as I stated, sometimes it is as I would have expected and sometimes the active sheet changes.
Has anyone experienced this behavior? Do have ideas on what I might look for to prevent this?
Thanks,
Steve
I have come across a problem that I cannot explain.
For some reason, when I execute the spin button, the active sheet changes. This happens only occasionally. I do not have any code to either select or activate that sheet, it just happens and not all the time. I have been trying to debug this by inserting into the various macros "msgbox activesheet.name" just to see what the current name of the active sheet ... and as I stated, sometimes it is as I would have expected and sometimes the active sheet changes.
Has anyone experienced this behavior? Do have ideas on what I might look for to prevent this?
Thanks,
Steve