View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Cell Toolbar Dilemma xl2013

I forgot to mention in Point 2 that Workbook level right click event
isn't necessary. Using the worksheet level BeforeRightClick event
doesn't avoid the problem.

Greg


I'm thinking that if your popup is activated by one of the delete
sheets it might be the cause. I always put something like that in an
events handler class. In your case I'd put it in ThisWorkbook (if you
don't know how to set up an events class). The events class allows me
to filter which sheets get which menuitems. I can't speak to sheet
deletes because my popup doesn't do that in the app I mentioned.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion