VBA toolbox displayed when macro is running

Milovan

New Member
Joined
Nov 1, 2021
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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?

vba.png
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,181,702
Messages
5,931,548
Members
436,792
Latest member
oriator

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top