Hey all found this Macro on a search,
which disables the cut/copy paste feature. Can any one make this work so that it actually disables the this feature but only in Column A
Please Login or Register to view this content.
Hey all found this Macro on a search,
which disables the cut/copy paste feature. Can any one make this work so that it actually disables the this feature but only in Column A
Please Login or Register to view this content.
Last edited by jeffreybrown; 11-23-2012 at 01:00 AM. Reason: Please use code tags...Thanks.
Hi,
Test your code again by replacing (or removing) the bold part below..
If Not Intersect(Target, Target.Parent.Columns(1)) Is Nothing Then
I am not able to check your code as there is no ToggleCutCopyAndPaste() function/procedure in your code. If possible then please add the same.
Regards
taps
Last edited by taps; 11-23-2012 at 10:03 AM.
Thanks Il Let you known how I get on
Hey,
This seems to have disabled Cut/Copy/Paste in all excel docs o my computer? I have disabled a Macro's but it still has them disabled
Hi,
Could you please provide the codes for ToggleCutCopyAndPaste() .
May be we can get some solutions there.
taps
I didnt change the above Macro as I didnt get around to it. I tested the above macro which disabled the Cut/Copy/Paste Feature then I created this post. It was only later when opening a seperate document that I noticed its disabled the feature across all excel Docs on my user log in any way.
Thanks For Your Help
Last edited by gmcgrane; 11-30-2012 at 05:47 AM. Reason: Forgot to Say Thanks :)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks