My "Personal.xlsb" contains a Userform, which comprises lots of command buttons to handle different daily tasks. Long time ago I have created a quick-access icon on top-left corner of Excel toolbar, in order to invoke it more quickly via shortcut "Alt + 1". Such way of calling this Userform has been perfectly well for me for over 2+ years.
But recently, when using "Alt + 1" to show up the Userform, the whole Excel freezes itself and seems to hang and malfunction(See attached image 1). Upon pressing "Ctrl + Break" to terminate the VBA code, Excel does respond but only to show up a freezing VBE screen (See attached image 2). Any clicking to close, maximize, minimize the Excel windows is in vain. What I could do is to "Ctrl + Alt +Delete" to kill the "Excel.exe" to restart. The weirdest part is that, sometimes the Userform can successfully be invoked to show up, and those command buttons can still function properly. But sometimes it just screws up and hangs the whole Excel.
I note that this problem always arises when my PC has been running for a long time. Already tried re-install Office Excel. Not working. Extremely clueless.
Help.
* PC︰Windows 10 Home Edition, 64-bit
* Excel︰Microsoft Office LTSC 2021 Professional Plus
image 1︰
image 2︰
But recently, when using "Alt + 1" to show up the Userform, the whole Excel freezes itself and seems to hang and malfunction(See attached image 1). Upon pressing "Ctrl + Break" to terminate the VBA code, Excel does respond but only to show up a freezing VBE screen (See attached image 2). Any clicking to close, maximize, minimize the Excel windows is in vain. What I could do is to "Ctrl + Alt +Delete" to kill the "Excel.exe" to restart. The weirdest part is that, sometimes the Userform can successfully be invoked to show up, and those command buttons can still function properly. But sometimes it just screws up and hangs the whole Excel.
I note that this problem always arises when my PC has been running for a long time. Already tried re-install Office Excel. Not working. Extremely clueless.
Help.
* PC︰Windows 10 Home Edition, 64-bit
* Excel︰Microsoft Office LTSC 2021 Professional Plus
image 1︰
image 2︰