Disable Cut, Copy, Paste in a workbook

[acsishere]

Dear Friends,

I got the following code (which disables the cut, copy, paste in a workbook) in this forum only. Thanks to the author. It works nicely. I applied the code as follows:

In workbook module:

Please Login or Register  to view this content.

In general module:

Please Login or Register  to view this content.

It disables shortcuts (Ctrl+x, Ctrl+C, etc) only. But, how to disable these commands in Menu control also?

Thanks in advance.

acsishere.

[royUK]

Your code disables all the copy options, what it doesn't do is re-enable it.

Please Login or Register  to view this content.

[/CODE]

[acsishere]

Thanks for your immediate reply.

I applied the code in the workbook. I don't understand how to apply it in the workbook. I copied Sub DisablecutAndPaste(), Sub EnablecutAndPaste() & Sub Error() into general module.

Besides, I copied the Sub WorkbookOpen() into ThisWorkbook module.

It doesn't disable the MENU COMMANDS (in Edit Menu). What is wrong in this code?

Thanks in advance.

acsishere.

[royUK]

The code is all in this workbook

[acsishere]

Thanks for the clear reply. But still it only disables the shortcuts. I need both shortcuts & Edit Menu commands (only cut, copy, paste, pastespecial) are also to be Disabled.

Thanks in advance.

acsishere.

[royUK]

Cut, Copy & Paste are disabled from the Edit Menu

[kgkev]

Thought this might be useful for something I have planned so I downloaded the workbook from royUK.

I get the following error when opening

Run-time error'-2147467259 (80004005)':

Method 'Enabled' of objec'_CommandBarButton'failed

Clicking debug highlights this

Please Login or Register  to view this content.

Some of the functions are disable but not all of them.

[acsishere]

Sir, I am using Office 2007. As I mentioned earlier, the Edit Menu functions are still working.

But you mentioned that it is disabled. I adopted the code as you described. Still where I am committing mistake?

Thanks in advance.

acsishere.

[royUK]

Excel 2007 is totally different, it doesn't have Commandbars so you would need to customise the Ribbon.

[acsishere]

Thanks for the clarification. Of course, temporarily I am doing with customizing the ribbon only. But the permanent solution? Any possibility to maintain compatibility thru VBA. Because, the data entry is done in Excel versions 97 - 2007.

Thanks a lot.

acsishere.

[Ben Shawn]

I copied the macro from link:
http://www.excelforum.com/excel-prog...-workbook.html.
Suppose to disable the copy & paste function for one workbook only.
The problem is all my excel workbook now have lost the copy & paste function. I have delete the macro and the worbook still I have not recover the copy & paste function.
Please help me.

[arthurbr]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.