Application screenupdating not working in excel 2016
BUUUUUUUUUTTTT I'm not married to "my way"; yet, having to make custom macros to set print areas/print reports and worksheets sounds like a pain in the butt. but I'm curious to explore some of the bugs that you are experiencing and seeing if we can easily find the reasons behind them.
With the file I attached in my previous post (in excel 2007 and excel 2013) the only issue I am experiencing is that when I close the workbook the ribbon remains minimized when I open another instance of excel.
If so, which should I use to be apply to all versions of excel 2007 and on?
If I switch between workbooks the ribbon minimizes and maximizes correctly upon activation/deactivation Addressing your specific issues: 1) The Send Keys command wasn't recognized properly - it called up Excel Help [F1] instead of using [Ctrl] [F1] 2) Because of that, there appears to be an issue with what window is active (Excel or VBA) and then the macro might halt.