How do I prevent my macro from hanging when Opening or Closing a workbook?

U

USAMax

Well-known Member
Joined
May 31, 2006
Messages
849
Office Version
  1. 365
Platform
  1. Windows
I have a macro that opens workbooks collects information and closes the workbook.

It runs perfectly when I have a break point in the program, I just have to hit F5 to continue.

I am running a UserForm as vbModeless to show where I am in the process.

When I let it run it locks on a few workbooks when it Opening or Closing a workbook. Currently it is always the 11th workbook.

Is there a fix for this?
 
Sort by date Sort by votes
Have you tried sprinkling some DoEvents statements in the code?
 
Upvote 0

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
You must log in or register to reply here.

Similar threads

A
  • Question Question
Open, Copy data and Close a workbook based on the names of the tabs in my active workbook
Replies
2
Views
137
Aurore87
A
S
  • Solved
How do I automate opening an excel document every 24 hours in the background, refresh connections, save and close the workbook in excel using vba?
Replies
6
Views
281
SPS41
S
T
  • Question Question
UserForm Close Event Hangs
Replies
0
Views
532
trough
T
L
  • Question Question
Macro Does Not Close Excel Workbook
2
Replies
14
Views
1K
Jeffrey Mahoney
Jeffrey Mahoney
S
  • Question Question
can't get a macro to work when i open a sheet
Replies
5
Views
245
still learning
S

Forum statistics

Threads
1,224,823
Messages
6,181,182
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

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
Back
Top