Hello, community,
I am developing a program in Excel using VBA and recently this strange behavior started to appear. I run VBA code (modules/userforms) with ribbon commands or with a double-click on the particular cells (both ways start the same code).
When I run the code from the ribbon command everything is ok but when I run the same code by double-clicking the cell, the toolbox shows until my custom progress bar is working.
When the job is done, the toolbox disappears together with the progress bar. To clarify, this happens no matter if the VBA editor is open or not.
This started recently after some code addition to existing and new modules/userforms and prior deleting recent changes and starting all over again, I wonder what is the reason for this behavior, have someone had a similar problem, and if someone knows about the solution. With my newly added code, I didn't change anything in the worksheet so it must be something in the triggered macro that causes this behavior.
Any idea?
I am developing a program in Excel using VBA and recently this strange behavior started to appear. I run VBA code (modules/userforms) with ribbon commands or with a double-click on the particular cells (both ways start the same code).
When I run the code from the ribbon command everything is ok but when I run the same code by double-clicking the cell, the toolbox shows until my custom progress bar is working.
When the job is done, the toolbox disappears together with the progress bar. To clarify, this happens no matter if the VBA editor is open or not.
This started recently after some code addition to existing and new modules/userforms and prior deleting recent changes and starting all over again, I wonder what is the reason for this behavior, have someone had a similar problem, and if someone knows about the solution. With my newly added code, I didn't change anything in the worksheet so it must be something in the triggered macro that causes this behavior.
Any idea?
