View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carroll[_2_] Carroll[_2_] is offline
external usenet poster
 
Posts: 31
Default Items Added to Right-Click Menu Only Visible From Some Sheets

Hello,

Using VBA, I add items to the right-click menu with Workbook_Open(),
then remove these items on Workbook_BeforeClose(). The odd thing that
I haven't been able to figure out is why I can see the items from some
sheets in the workbook, but not other sheets. I would like the items
to be available to me, regardless of what sheet I'm on. Does anyone
know why this happens, and how I can fix it?

Thanks,
Carroll Rinehart