Customising "right click" menu - add seperator

I have a need to for the ability to run macros from "right clicking" on a cell (must work in Excel 2003) . I have achieved this by using the following code:

Please Login or Register  to view this content.

I would like to be able to do the following:

1. put a horizontal line separator between my "Custom menu" and the remainder of the standard Excel context meny (when you right click)

2. put a horizontal line separator between Function 2 and Function 3 on my custom menu as well.

Any help appreciated - i am sure this is easy to do.

Regards

Hi antoine,

Excel does have an event called Before_RightClick and you put code behind the worksheet to execute this code.

See some examples:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=437
http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm
http://www.ozgrid.com/Excel/free-tra...a1lesson16.htm

No_Im_Spartacus, it is unlikely that Antoine is monitoring this thread. This thread is 4 years old and he hasn't posted to the forum since then. I suggest that as a new member you direct your energies towards current threads. Thanks.

Thread closed.