View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nosliwgerg2@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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