Forum

Macro time waiting ...
 
Notifications
Clear all

Macro time waiting opening workbook

3 Posts
2 Users
0 Reactions
62 Views
(@bandikukargmail-com)
Posts: 23
Eminent Member
Topic starter
 

hi master... can you help me to code a timeout macro when opening a file...

 

I have a workbook with a size of 49 mb... when I open the workbook it takes a long time, because it takes a long time to wait for it without seeing when it will open... therefore is there a macro code that when the workbook is open it will automatically appear when the countdown time or vice versa? counting until the workbook opens... thanks for your attention...

 
Posted : 10/10/2021 4:51 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Bandi,

VBA isn't enabled by default as this poses a security risk.  If it is enabled it should not be.

So you can't do what you ask because 99.99% of PC's will have VBA off when opening a workbook, and it requires user interaction to enable macros.

Regards

Phil

 
Posted : 12/10/2021 9:29 pm
(@bandikukargmail-com)
Posts: 23
Eminent Member
Topic starter
 

Thanks phil... ^_^

 
Posted : 13/10/2021 5:28 pm
Share: