UGTS Document #60 - Last Modified: 8/29/2015 3:23 PM
Odd Excel Bugs

Excel has a few odd bugs which can be really hard to figure out. Here are some of the more commonly encountered ones:
  • VBA Stops After Calling Workbook.Open - If you're executing VBA, and the VBA calls the Workbook.Open method, and suddenly your VBA stops executing without any error or explanation, it may be because you have the Shift key held down, or the VBA was invoked by a Macro whose shortcut key included holding the Shift button down. This is a known issue with Excel. The workaround is to use a shortcut key for the macro which doesn't require the shift key to be held down.