$$Excel-Macros$$ VBA macro runs fine, but freezes if I try to do ANYTHING else while it's running

2011-08-03 Thread Rruffpaw
I have a very large Excel spreadsheet (13 MB) with several macros. One of them runs a loop with multiple commands. The macro runs fine, as long as I sit back and just watch it run. If I click on another window however, it invariably freezes and I have to terminate Excel. Any ideas on how I can re

$$Excel-Macros$$ Right-Click Functionality disabled with Hidden Command Bars

2011-02-12 Thread Rruffpaw
I have hidden all command bars in my workbook with For Each bar In Application.CommandBars bar.Enabled = False Next bar and this properly hides all command bars giving me a lot more real estate in each worksheet However, the right-click functionality is completely disabled. Is there any wa