Very strange indeed!!!!!
 

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

Very strange indeed!!!!!
 

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