Move Copy problems Excel 365

[DarbyBrown]

I have been running Excel 365 for 3-4 months and have just ran into a problem with the move/copy function. I've had no problems with this previously in 365. Now every Workbook and every sheet has the move or copy selection grayed out and not accessible. Everything two days ago was fine, I added a couple of worksheets to a workbook using the Move or Copy function with no problem. Today I couldn't access that function. Tried in other Workbooks with the same problem. HELP!!!

 

[Yongle]

Caused by protection?
Greyed out Move or Copy can occur where either the workbook or worksheet protected applied
Click on the Review Tab.
- the workbook is protected if "Protect Workbook" icon is highlighted
- the sheet is protected if visible icon option is "Unprotect Sheet"
- unprotecting the workbook or worksheets should deal with your issue


If protection is not the issue, perhaps the command bar need re-setting?
To reset the relevant command bar to default...

1 Go to VBA window with {Alt}{F11}
2 Open up the immediate pane with {CTRL} G
3 Type into the immediate pane
Application.CommandBars("Ply").Reset
...followed by {Enter}
4. Type into the immediate pane
Application.CommandBars("Ply").Visible=True
...followed by {Enter}
5.Back to Excel with {Alt}{F11}

 

[DarbyBrown]

Yongle: Thanks for the help, first suggestion didn't work, but second did. I have access to Move or Copy through all the workbooks. I have no idea how I messed it up, but all is well now. Thanks again
Darby

 

[Yongle]

Are you using any add-ins?