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
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.
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 ?
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....
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.
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?
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.
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
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
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^"
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?
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?
Thanks Daniel ,you are the VBA hero on planet earth.Didn't ever think I could do this on Excel VBA
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
Hello Dan.! can we stop user to copy in any ways (either Ctrl+C or using mouse) without protecting sheet?
Does it work when the file is opened from other computers? Can we control in this way?
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.
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.
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 ?
Exactly what I was looking for. Thanks, Dan.
Maarten Gijsel You're so welcome, Maarten. Thanks!!
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....
Great video! One more question how to do the same for upper left corner (Clipboard ribbon)?
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.
how about how to fix right click menu always appearing even though im not clicking right click
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?
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.
Fantastic Scott. Yes, making things error and mistake proof is all a part of the automation process. You da man!
holla, can you teach me about how to disable copy cut and paste on pdf using visual basic coding?
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
Thanks. waiting for more trics.
But I can still copy and paste the contents using Ctrl C and Ctrl V, respectively.
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
does that disable(or hide) the button in the ribbon(at the top) as well?
This particular command just affects the cells right click options, I believe.
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^"
krn14242 NICE! Thanks krn14242
thanks alot for ur video brother
You are most welcome, Serge
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.
Fantastic video !!! Thanks Dan !!!
Thanks Prince!
Why did I make an error?
Run-time error '5
i disable copy and cut but i c'not restore them agin how can i do plz
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?
Thanks for sharing knowledge..
when i hide rowsor cull and clozedsheet i loss them howcan i restore them plz
Thanks Dan. Pretty cool.
You're so welcome. Thanks krn
very good & many thanks
You're very welcome Ahmed. Thanks for watching!
Doesn't work for me
Big Like :)
Back at ya, Mohammad Taha!
⭐️⭐️⭐️⭐️⭐️
@krn14242 ,thanks.
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?