Activate Move or Copy Sheet

[Alex Jee]

I have accident press a macro that disable the Move or
Copy Sheet of the right click at Sheet Tab. How do I
activate back this button.

 

[Dave Peterson]

If your workbook is protected, then that item is disabled.

If move/copy is disable for each workbook, then you could try this:

Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-G (to see the immediate window)

Type this in and hit enter:
application.CommandBars("ply").Controls("move or copy...").Enabled = true

Back to excel and check to see if it worked.

If it didn't, you could try resetting all the options on that toolbar.
application.CommandBars("ply").reset

And finally, if both of these didn't work, you could reset all your toolbars:

close excel
Windows Start Button|Find files
Look for *.xlb (where excel stores customized toolbars)
rename all you find to *.xlbOLD.

restart excel and try it out.

If it worked, then dump those *.xlbold files.

Both the second and third attempts may clean up more than you want. You might
have to rebuild any customize toolbars that you've added.