Okay, this is a tricky one I think. I have popup menu (right click) that fires when a user clicks in any cell of column 2. Here is the problem. I create new worksheets (Sheet.Add)in a very sophisticated macro, since the rightclick fires the event (Worksheet_BeforeRightClick)the ability to capture this in any of the newly added sheets is not available (no code at the worksheet level) How can I capture the event another level up the application chain (i.e. at the workbook level)? This would allow me to globally catch the user event regardless of which sheet is active at the time.
Remember, I create the sheets new and hence the sheet is void of code prior to the user getting the workbook. I use a template as part of this big macro and I could copy a blank sheet instead of adding a new empty one. Is there another way?
Guy
Remember, I create the sheets new and hence the sheet is void of code prior to the user getting the workbook. I use a template as part of this big macro and I could copy a blank sheet instead of adding a new empty one. Is there another way?
Guy
