Notifications
Clear all
VBA & Macros
3
Posts
2
Users
0
Reactions
62
Views
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
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
Topic starter
Thanks phil... ^_^
Posted : 13/10/2021 5:28 pm