Disable Right click on Macro Button in a worksheet

[RAJRAJ85]

Dear All

I would like to know if there is a way in which we can disable right click over a macro button or any button in a sheet? I have tried below, but only disables right click

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
End Sub

Kindly help with your valuable ideas and suggestions friends

Regards

[Keebellah]

Protect the worksheet

[RAJRAJ85]

Hi Hans

Thanks for the response. My only issue is I will need to copy /paste certain data into the sheet and then run the macro. So from the protect shetoption, which options i need to tick to get no right click on macro button? Plz a advise

Thanks

[Keebellah]

According to me there is no specific option for that.
Just make sure the cells where you will be pasting data are not locked when the worksheet is protected, make sure that other requirements like sorting autofilter etc are accessible and when the sheet is protected right click is not permitted on a button.

[RAJRAJ85]

Thanks Hans, my other question is, how do i lock only the top 7 rows and the rest all unlocked in sheet? I have checked the buttons and with your option it doesnt shows right click !! thanks you are a genius!!

[Keebellah]

I don'w know how large you 'free'area is but you can select all cells (Ctlr + A) and right click remove the locked checkmark.
Then select the top 7 rows and x columns and right click and set the checkmark in locked.
Protect the worksheet (with or without password) and remove the checkmark select locked cells) that's it.
It's all in Excel help, no rocket science here.

[RAJRAJ85]

Great thanks Hans