July 20, 2020
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...
October 5, 2010
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.