Thanks SkipVought but the worksheet password can be broken with the appropriate software, hence my desire to prevent the drag/drop....but I guess it cannot be done with Application.OnKey (or similar) to surpress ctrl + mouse down?
Thanks everyone
Yes, it's well locked down but I would like to improve the security by preventing a worksheet being dragged/dropped by stopping Ctrl + mouse down or just mouse down.
I can intervene to stop Ctrl being used by using Application.OnKey but that captures keystrokes not mouse clicks. So I guess I...
Hi
I'm trying to stop a worksheet being copied by preventing the use of ctrl + mouse click to drag and drop it to a new workbook.
Is it possible to capture 'mouse down' and use it with Application.OnKey?
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.