Can't Move/Copy or Create Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1497246%22%20slang%3D%22en-US%22%3ECan't%20Move%2FCopy%20or%20Create%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497246%22%20slang%3D%22en-US%22%3E%3CP%3EPlus%20symbol%20next%20to%20sheet%20tabs%20is%20grayed%2C%20right%20clicking%20on%20sheet%20tabs%20Move%2FCopy%20grayed.%20Sheet%20and%20Workbook%20are%20unprotected.%20What%20am%20I%20missing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1497246%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1498514%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Move%2FCopy%20or%20Create%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1498514%22%20slang%3D%22en-US%22%3ESheets%20and%20workbook%20ARE%2FWERE%20un-protected.%20Move%2FCopy%20sheet%20function%20is%20grayed%20out.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1497644%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20Move%2FCopy%20or%20Create%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1497644%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F713755%22%20target%3D%22_blank%22%3E%40Eric_Wentorf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Workbook%20Structure%20must%20be%20protected.%20To%20confirm%20this%2C%20go%20to%20Review%20Tab%20and%20under%20Protect%20Group%2C%20do%20you%20find%20Protect%20Workbook%20highlighted%20with%20grey%20color%3F%20If%20you%20click%20the%20Protect%20Workbook%2C%20if%20it%20is%20protected%20then%20it%20would%20ask%20for%20a%20Password%20to%20unprotect%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Workbook%20Protected.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202093i065BE5BD9360F823%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Workbook%20Protected.jpg%22%20alt%3D%22Workbook%20Protected.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Plus symbol next to sheet tabs is grayed, right clicking on sheet tabs Move/Copy grayed. Sheet and Workbook are unprotected. What am I missing?

5 Replies
Highlighted

@Eric_Wentorf 

The Workbook Structure must be protected. To confirm this, go to Review Tab and under Protect Group, do you find Protect Workbook highlighted with grey color? If you click the Protect Workbook, if it is protected then it would ask for a Password to unprotect it.

 

Workbook Protected.jpg

Highlighted
Sheets and workbook ARE/WERE un-protected. Move/Copy sheet function is grayed out.
Highlighted

@Eric_Wentorf 

Is that for some particular file or for any one?

Highlighted
Two that I have observed this behavior. Both are based on the same template, developed by a 3rd party, who is long gone. The workbook performs a number of statistical calculations after you un-protect the sheets and add data.
Highlighted

@Eric_Wentorf  are these sheets macro enabled? (.xlsm or .xlsb or .xls)  and do you know if there is VBA code?