Disable Items from Right Click Menu in Excel VBA

[@babzo1]

Thanks Daniel ,you are the VBA hero on planet earth.Didn't ever think I could do this on Excel VBA

[@maartengijsel11]

Exactly what I was looking for. Thanks, Dan.

[@ExcelVbaIsFun]

Maarten Gijsel You're so welcome, Maarten. Thanks!!

[@sergedusabirane9040]

thanks alot for ur video brother

[@ExcelVbaIsFun]

You are most welcome, Serge

[@RealTakunia]

Thanks. waiting for more trics.

[@PrincePedia]

Fantastic video !!! Thanks Dan !!!

[@ExcelVbaIsFun]

Thanks Prince!

[@varunk8375]

Hello Dan.! can we stop user to copy in any ways (either Ctrl+C or using mouse) without protecting sheet?

[@PankajSharma-zp4fu]

Thanks for sharing knowledge..

[@richardgreenwood9026]

Hi, great video helps a lot. I need to be able to restrict the right click shortcut menu in a cell to show paste values and disable all other paste options such as formulas and formatting. Can you explain how to do this as I need to stop my users from over writing conditional formatting which is what paste all is doing. Can you help

[@krn14242]

Thanks Dan. Pretty cool.

[@ExcelVbaIsFun]

You're so welcome. Thanks krn

[@ahmedzakaria11]

very good & many thanks

[@ExcelVbaIsFun]

You're very welcome Ahmed. Thanks for watching!

[@scottmarshburn5143]

Cool! can't wait for more on this subject I am always looking for a way to direct users that are unfamiliar with excel in a way that they can't screw something up. Like the Idea of adding to and or customizing the ribbon.I have played around with this. But never thought of doing it with code.

[@ExcelVbaIsFun]

Fantastic Scott. Yes, making things error and mistake proof is all a part of the automation process. You da man!

[@TSLEAcademy]

How to disable shortcut keys in ms excel by VBA macro. Please let me know, if you made any video about about disable shortcut keys.

[@amritsubedi5453]

Does it work when the file is opened from other computers? Can we control in this way?

[@priyatripathy7929]

Hi, first of all thanks for all the videos. they are just great. have a query if you can help. i have a workbook containing multiple sheet and the last one contains Pivot table collating all data related to all other sheets. i want the user not able to delete these pre-set sheets. i cant use "protect workbbok" as it will restrict the user to get data from the Pivot table. i just want to disable the "Delete" option from the specific sheets. The user should still be able to click the pivot table and new sheet shall open and he shall be able to delete it. Hope you can guide. let me know in case you need any other details. Thanks.

[@aleksandraadamczyk3999]

Great video! One more question how to do the same for upper left corner (Clipboard ribbon)?

[@adoniswalk]

There is a way to minimize the ribbon for the workbook but it really locks the user out from the entire ribbon. Need to be careful and considerate if it's really necessary.

[@alyannaogoy549]

how about how to fix right click menu always appearing even though im not clicking right click

[@konijay]

does that disable(or hide) the button in the ribbon(at the top) as well?

[@ExcelVbaIsFun]

This particular command just affects the cells right click options, I believe.

[@krn14242]

ExcelVbaIsFun You are correct. You can also disable the control c, x, v with Application.OnKey "c^", "" this would disable the Control C (Copy) function. Renable with Application.OnKey "c^"

[@ExcelVbaIsFun]

krn14242 NICE! Thanks krn14242

[@sergedusabirane9040]

Hi brother i am Serge in fact I would like that you help me for this issue i come to end my vba project and is ready to be used now so, what that for those i want to offer the product have not the right to copy and distribute it. can u find a way using vba codes? or another one you want ?

[@thomasfergusen5144]

hello i want to ask that how can be make pasted only values to cells (prevented paste format etc, but can typed in by using key) in excel. İs it possible?

[@BulkCarrierChiefMate]

this is very helpful so thank you very much!!! there's another thing.... I am very very eager to know how to disable copy/paste function of a certain excel file. the thing is i have a file in a flash drive that i don't want to be copied by other users even if they borrow my flash drive. could you please help me with this....

[@usano-goldiemathematics9382]

But I can still copy and paste the contents using Ctrl C and Ctrl V, respectively.

[@ExcelVbaIsFun]

Correct, if you need to disable those as well, you'd want to use an application.OnKey command to make those keyboard combinations either useless or have them run a specific macro of your choosing. Thanks Dan

[@nurulaqilah5342]

holla, can you teach me about how to disable copy cut and paste on pdf using visual basic coding?

[@pbtechpro]

sir, when i applied your code the "CUT" option total hide from my excel workbook , if i open new workbook its shown same , the cut option totally hide, please explain the code how to recover the "CUT" option

[@EmmanelMin1]

If it is gone forever, how to restore it? I was interrupted and did not place in the deactivate and now cut is gone on all my worksheets.

[@movietime9621]

when i hide rowsor cull and clozedsheet i loss them howcan i restore them plz

[@movietime9621]

i disable copy and cut but i c'not restore them agin how can i do plz

[@jekjek9570]

Why did I make an error? Run-time error '5

[@MohammadTaha]

Big Like :)

[@ExcelVbaIsFun]

Back at ya, Mohammad Taha!

[@sauravghosh1588]

i, Can you share me how to disable the ribbon in excel with the help of vba, because i try to hide the ribbon with vba but unfortunately if i press ctrl+F1 it unhide the ribbon. please share me!!! 1. How to disable the ribbon in excel with help of vba? 2. How to disable the Home Tab, Insert Tab or single sperate tab in excel with help of vba?

[@redhaakhund1271]

⭐️⭐️⭐️⭐️⭐️

[@davidecorengia4397]

Doesn't work for me

[@babzo1]

@krn14242 ,thanks.

[@thomasfergusen5144]

hello i want to ask that how can be make pasted only values to cells (prevented paste format etc, but can typed in by using key) in excel. İs it possible?