'Right Mouse Click' disabled

MSFN Forum: 'Right Mouse Click' disabled - MSFN Forum

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

'Right Mouse Click' disabled Excel 97 - VBA Rate Topic:

#1 Carl_Maddox

Group: Members
Posts: 3
Joined: 31-May 05

Posted 31 May 2005 - 04:03 AM

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