PDA

View Full Version : Unable to copy, paste; Right click disabled



ssafiri
06-04-2009, 08:57 PM
How can I unable copy, paste of right-click menu again?
I used the code from one of the threads to disable copy/paste here but now I can’t find the code to disable it.:dunno
When I open VB Editor its not in blank workbook I mean even it disables or new workbooks.


THANKS ALOT

ssafiri
06-04-2009, 09:56 PM
How can I unable copy, paste of right-click menu again?
I used the code from one of the threads to disable copy/paste here but now I can’t find the code to disable it.:dunno
When I open VB Editor its not in blank workbook I mean even it disables or new workbooks.


THANKS ALOT


any help??

p45cal
06-05-2009, 01:32 AM
re:"I used the code from one of the threads to disable copy/paste here"

Which thread, what code? It might help.

ssafiri
06-05-2009, 02:59 AM
re:"I used the code from one of the threads to disable copy/paste here"

Which thread, what code? It might help.

I find it here:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

any idea?

mdmackillop
06-05-2009, 05:40 AM
Check Personal.xls and any workbooks in your XlStart folder.

ssafiri
06-05-2009, 06:30 AM
Check Personal.xls and any workbooks in your XlStart folder.

I don't have them.is there any solution there?

lucas
06-05-2009, 07:24 AM
Maybe download Kens workbook from the link again......open it and close it. It toggles and resets everything when you close it.

What version of Excel?

ssafiri
06-05-2009, 07:01 PM
Excel 2003 :bug:

ssafiri
06-07-2009, 01:20 AM
Excel 2003 :bug:

help!!!!!!!!:banghead:

mdmackillop
06-07-2009, 01:39 AM
If you're really stuck, why not reinstall Excel

MaximS
06-07-2009, 02:27 AM
try below:

1. Menu >> Help >> Detect and Repair
2. Tick 'Discard my customized settings and restore default settings'
3. Click 'Start'

Aussiebear
06-07-2009, 02:59 AM
Ron Debruin has the following which might be helpful

The examples below disable all the "Copy" controls in all command bars.
Note: Every "Copy" control in the Menu Bar, Toolbars and right click menus

If you use Excel 2000-2003 you can use the code below that use the Office.

CommandBarControlSub MenuControl_False()
' Excel 2000 - 2003
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=19)
Ctrl.Enabled = False
Next Ctrl
End Sub

You might be better off going to the following link and read it through fully.

http://www.rondebruin.nl/menuid.htm

You will also note that in the material Ron has provided there's images showing all the ID's for Menu Items for Excel 2003

ssafiri
06-09-2009, 02:54 PM
Ron Debruin has the following which might be helpful

The examples below disable all the "Copy" controls in all command bars.
Note: Every "Copy" control in the Menu Bar, Toolbars and right click menus

If you use Excel 2000-2003 you can use the code below that use the Office.

CommandBarControlSub MenuControl_False()
' Excel 2000 - 2003
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=19)
Ctrl.Enabled = False
Next Ctrl
End Sub
You might be better off going to the following link and read it through fully.

http://www.rondebruin.nl/menuid.htm

You will also note that in the material Ron has provided there's images showing all the ID's for Menu Items for Excel 2003

Thanks guys,
I did detect and repair but my problem with copy/paste in right click menu is already exist.
I do reinstall excel but I want to know why this macro disabled all excel workbook not activate one.
Thanks

ssafiri
06-09-2009, 03:01 PM
Thanks guys,
I did detect and repair but my problem with copy/paste in right click menu is already exist.
I do reinstall excel but I want to know why this macro disabled all excel workbook not activate one.
Thanks


I did it!!!:rotlaugh:
I find excel.xlb file and rename it ExcelXLB.old in Microsoft folder and it's done!
Thanks to all

mdmackillop
06-10-2009, 05:12 AM
Now that you have the solution, and doing a seach on the named file.
http://support.microsoft.com/kb/327913