Disabling KeyBoard Right Key Button & Right Click on Sheet Tab

Hi All,

with help from peer here I am able to start with VBA but due to my low understanding of it continuously facing problems.

I been able to disable Mouse Right click and Del Key in the sheet however not finding a way to disable the Right Click Key on the Key Board.

Also despite Right Click being disable in the workbook I can still do right click on the Sheet Tab further I cant barred option of inserting or deleting the sheets from the workbook.

I believe all this can be solved by protecting the workbook but asap i do that none of the macro in the workbook work as it have hidden sheets which become visible on click on command buttons.

Have attached the Sheet all passwords available in the code itself hence I dont need to give it separately.

Awaits earliest +ve response.

Reg,
Vishu

Hi Vidya,

Thanks for the reply, however I have already done that and its not working, i have already explained the reason of it in my query that if I do so the Macros are not working....I have attached the workbook for reference, please do have a look again.

Hope to have your continuous help.

Reg,
Vishu

been able to do it with some R&D and below code...

Please Login or Register  to view this content.