mohitbang
09-19-2014, 02:04 AM
Hi friends,
I was stuck with task for a long time, wherein I had to disable all options of Cutting, Pasting Data (Copying should be enabled) in a workbook (Excel 2007).
And with the help of Experts from VBA Express itself :clap:, I was able to crack it down partially i.e. the code disables the shortcut Keys (ctrl + X, ctrl + Y) and the cut, paste options on right click. But it is not disabling the Clipboard Section (Cut, Copy, Paste) under Home Tab and also the feature of "Fill Handle".
Please Help.!!!
Would appreciate any help.... :)
I was stuck with task for a long time, wherein I had to disable all options of Cutting, Pasting Data (Copying should be enabled) in a workbook (Excel 2007).
And with the help of Experts from VBA Express itself :clap:, I was able to crack it down partially i.e. the code disables the shortcut Keys (ctrl + X, ctrl + Y) and the cut, paste options on right click. But it is not disabling the Clipboard Section (Cut, Copy, Paste) under Home Tab and also the feature of "Fill Handle".
Please Help.!!!
Would appreciate any help.... :)