Vba status bar stops updating

14 Mar

[journaling], [speech], [ext], [insert], [lastcell], [addins], [slowmacros], [speedup VBA], [recalculation], [openclose], [calc], [1-2-3], [memory], [leakage], [GDI], [objects], [pagesetup], [swapfiles], [VBE], [files], [elimxused], [defrag], [formats], [likeformats], [volatile], [checklist], [slowxp], [moreitems], [grayed], [temp], [timer], [reg], [related], [startup], [warnings], [search], [mskb], [slow], [updatesites], You are probably visiting this page because you were referred to it by someone in a newsgroup.Because of the nature of such problems, it is important to provide feedback when you solve your problem by replying back to the thread so that others can be helped and so that pages such as this can show relevant information.

Alternately Dave Peterson has four macros involved in adding another entry to the file menu to bring up the old menu (misc, 2004-07-14) Changes to later windows systems, and later Excel versions is invariably going to have much higher memory requirements, from others sounds like you should have 512MB RAM and turn off features.

Some specific tweaks for Excel 2003 (spinner 2005-04-08), appear to be the speech recognition above, no improvement in zooming graphics and fonts (keep zoom at 100%).

Auto Recovery is improved but you have to respond when Excel is going down, and decide which file (old or recovered) to use later but no peeking.

For example, to make it for 2017, just change the value in A2 to 2017.

Also, you need to update the holiday list for the specified year. You also need to specify the same code in cells NL5: NU5.