Can't Move/Copy or Create Sheet

Question

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?

subodh_tiwari_sktneer · Answer

Eric_Wentorf&nbsp;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.&nbsp;

eric_wentorf · Answer

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

sergeibaklan · Answer

Eric_Wentorf&nbsp;
Is that for some particular file or for any one?

eric_wentorf · Answer

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.

mtarler · Answer

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

Forum Discussion

Can't Move/Copy or Create Sheet

Share

Resources