Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Very urgent Please - lock control D feature


Hello Team

Please help me urgent, God Bless you

I had created a roster for my students, where they can apply. 

I have given the formula for dynamic formula and duplicate is not allowed. however whenever they manually try to update the same text, it gives error (Perfect)

But when they try to copy the cell and past it, error doesnt pop up :-(

Also, when they perform ctrl + D and copy above text... duplication error doesn't pop up.

Please help, I need to submit the final copy today




@ Prathik

Please do not state that your problem is urgent (even though it might be for you).

@ Don

Without wanting to limit free speech, do you think words like "urgent" should be disallowed from question titles? (Or at least warn users NOT to expect rapid replies to their new questions- even though they might be provided a lot of the time?)
John_Ru (rep: 3992) Jul 4, '22 at 11:11 am
Hi John
Which one should I use to restrict ctrl d and copy past option
Please help

Sub HideAll() ' Excel VBA Tutorial - https://www.TeachExcel.com          ' Hide the Horizontal Scroll Bar     ActiveWindow.DisplayHorizontalScrollBar = False          ' Hide the Vertical Scroll Bar     ActiveWindow.DisplayVerticalScrollBar = False          ' Hide the Row/Column Headings     ActiveWindow.DisplayHeadings = False          ' Hide the Worksheet Tabs     ActiveWindow.DisplayWorkbookTabs = False          ' Hide the Status Bar (bottom of the window)     Application.DisplayStatusBar = False          ' Hide the Formula Bar     Application.DisplayFormulaBar = False          ' Hide the Ribbon Menu and Quick Access Toolbar     Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"          ' Display Full Screen     'Application.DisplayFullScreen
prathikpp143 (rep: 2) Jul 4, '22 at 12:34 pm
Prathik. You midunderstand- neither disables the Ctrl+D key combination (but prevents the ribbon button being used). I'll delete my answer (since it doesn't directly address your problem and I think it would be a mistake for you to pretend to others -your teacher I think you said- that you know VBA well. 

Normally, this point should be in the discussion to the answer, not your question. 
John_Ru (rep: 3992) Jul 4, '22 at 1:04 pm
So, There is no solution for my question :-(
prathikpp143 (rep: 2) Jul 4, '22 at 8:34 pm
John, right on about not responding to "urgent" - this is a free forum with volunteers Prathik. I don't know that banning the word will be effective though since it could be useful in some cases like, "How to show a user an urgent alert in vba?"
don (rep: 1979) Jul 5, '22 at 11:33 am
Prathik, sounds to me like protecting the sheet is your best option. Play around with the restrictions that that allows you to add.
don (rep: 1979) Jul 5, '22 at 11:34 am
@Don Both comments make sense, thanks . You perhaps guessed I was reluctant to suggest a solution based on using OnKeys, given that could cause issues unless care is used.
John_Ru (rep: 3992) Jul 5, '22 at 11:43 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login