Hi all,

I have been previously working on excel 03 pro, and as part of the
workbook I needed to disable the right click menu on some of the pages. This
worked fine and still does in excel 07.

Been using excel 07 recently, and on re-testing the code in excel o3 I have
found the right click function is called ( worksheet function before right
click), runs the macro but regardless still shows the right click menu.

Cancel = true and I have also check to make sure it has been called (put a
break point at code line) and it is.

I have not changed this section of code, since it was first implemented
months ago, and there has been no issue with it, until I have recently been
using excel 07, and it still works as it should in excel 07 (right click
menu not displayed).

I have deleted the lines of code and let excel 03 recreate them, but this
still doesn't work.

Can any one help

Thanks in advance


Anthony

The mystery solved. I tried a repair install of office etc... but I found it
wasn't the workbook / code because it worked OK on a works version of excel
03.

The only thing different was a copy of saga accounts was installed and had
an addin for excel.

I removed saga and everything was working again.

Yippee

Anthony


"Anthony" wrote in message
...
Hi all,

I have been previously working on excel 03 pro, and as part of the
workbook I needed to disable the right click menu on some of the pages.
This worked fine and still does in excel 07.

Been using excel 07 recently, and on re-testing the code in excel o3 I
have found the right click function is called ( worksheet function before
right click), runs the macro but regardless still shows the right click
menu.

Cancel = true and I have also check to make sure it has been called (put a
break point at code line) and it is.

I have not changed this section of code, since it was first implemented
months ago, and there has been no issue with it, until I have recently
been using excel 07, and it still works as it should in excel 07 (right
click menu not displayed).

I have deleted the lines of code and let excel 03 recreate them, but this
still doesn't work.

Can any one help

Thanks in advance


Anthony