With XLSPadlock security, All sheet disable right click / double click only one sheet has right click option

I have an Excel Workbook, having 10 Sheet. I want all 9 Sheet to disable right click and double click, but one sheet has option to right click, as have option this with XLSPadlock security option?

Have you tried to set some Excel cell permissions?
Anyway, disabling right click/double click cannot be done per sheet in XLS Padlock itself. It is global.

Thanks for your prompt response. i try below code code for enable in a particular sheet and provide certain row to delete, but not success.

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = False 'Right Click is Enable
End Sub

If you have some other option or code to enable right click in a particular sheet will be helpful.

Can you check if your VBA event is correctly fired by adding a simple MsgBox to your code?
Worksheet_BeforeRightClick