Can't Move/Copy or Create Sheet

Copper 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?

6 Replies

@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

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

@Eric_Wentorf 

Is that for some particular file or for any one?

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.

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

@Subodh_Tiwari_sktneer yes it is protected & asking for password but i don't know it. kindly let me know if there is way to sort ?