'Right Mouse Click' disabled

[Carl_Maddox]

Hi,

I've customed the 'Worksheet Menu Bar' items in Excel 97. I wanted to disable the right mouse click and the double click for the main menu bar, thus, providing protection.

I disabled the right mouse click by:

Application.CommandBars("Toolbar List").Enabled = False

which was fine.

I then disabled the double click by:

Application.DoubleClick = "DisableDB"

Sub DisableDB()

Application.CommandBars("Toolbar List").Enabled = False

End Sub

My problem is, I have now set Application.DoubleClick = "", however, the double click returned but my right mouse click (for the pop up menu) on a worksheet is not working.

Any ideas would be appreciated.

Many Thanks,

Carl