Cell Toolbar Dilemma xl2013
Thanks again Gary for replying.
I ran your code and, unfortunately, it does the same thing. After running it, the mouse wheel was not recognized and I could not close the workbook. Adding another sheet (which makes it active), then returning to the Instructions worksheet through the UI fixed it.
I used a new workbook devoid of additional code. I commented out my version of DeleteReportSheets and included MsgBox responses within your code to make sure it was fully executing. It was.
I mentioned that I had already tried activating the Instructions worksheet before doing the deletions, and it didn't help. Also, as mentioned, if I don't create my own popup, just add my controls to the Cells popup, this doesn't happen. Just the annoying "Paste Options:" control gets added and I can't prevent it (gets added after the right click event is processed).
So I guess all we can do is see if someone else running 8.1 / xl2013 confirms or denies the problem.
Thanks again.
Greg
|