PDA

View Full Version : Cut Copy Paste disable in Excel 2007



marzook
03-15-2009, 10:25 AM
How to disable cut copy paste in Excel 2007 from Home tab

marzook
03-15-2009, 10:41 AM
Any one can help,

BrianMH
03-15-2009, 10:48 AM
Hi mate,

A little patience goes a long way. Remember people here are not being paid. A quick google search of disable cut copy and paste in excel returns the top result as http://vbaexpress.com/kb/getarticle.php?kb_id=373

Now this isn't through the Home tab and I don't believe there is an option anywhere in excel. Just remember bumping like this on any forum is generally considered impolite.

marzook
03-15-2009, 11:00 AM
Please let me clear, As mentioned i got the above result and i applied on my file averything is working in excel 2007 except the buttons copy, cut, paste which shows on Home Tab still is enabled .....

I have tried to download the excel file which availble on above link for checking the file in 2007 but unable to download , correption on Zip file........

Could you please help....plz plz plz......

Zack Barresse
03-15-2009, 11:15 AM
The code is posted with instructions on how to install/use. If you cannot follow that, there isn't much we can do for you here. Please read the entire link and everything on that page.

marzook
03-15-2009, 11:22 AM
I have read and applied ...sorry to repeat its not woking in 2007 version, working only on shortcut keys, right click menu but not working the toolbars ........But its woking in earlier versions.....

marzook
03-15-2009, 11:50 AM
Hey Mates...

I have tried again, its not working in 2007 version, i m wndring on wht accont you are telling to check the above links...........

Hope a posetive responds....

Zack Barresse
03-15-2009, 11:55 AM
What do you mean, what account? You mean your user account? Do you have more than one? Elaborate a little on that.

marzook
03-15-2009, 12:01 PM
If possible can you please send me the file which availble on the above link.. i am getting the alert as the file is correpted

mdmackillop
03-15-2009, 12:41 PM
I would confirm tat all KB zip files appear to be corrupted.

Zack Barresse
03-15-2009, 12:59 PM
We had an issue with every single attachment when we switched servers here last month. The code does work. It does not, however, customize the Ribbon, which is a different situation altogether.

marzook
03-15-2009, 10:39 PM
Thanks for the help....

I have attached the file here, Can you please advise and its in a shared folder and going to be used by diffrent dipartments (more than 10) and i dont think its would be practical to customize ..

marzook
03-16-2009, 01:36 AM
Please awaiting for help.........

Zack Barresse
03-23-2009, 12:56 PM
Well, we need to know what it is you want to do first. Do you want to disable Ribbon items with this workbook? If so, you'll need to use some custom XML to disable those items. The code in the KB link referenced earlier in this thread has code to disable the control ID and shortcut keys, but that's it. It sounds to me that you need some Ribbon customizations to take those options away from the Ribbon.