Inserting a worksheet is disabled-Not protected-No Macros

**jacteaux** · 07-12-2016, 11:40 AM

Hello all,
Issue: Inserting a worksheet is disabled.
Could anyone offer assistance please?

I am using Excel 2013.
I have a worksheet from another source that was protected and now is not.
The workbook contains no macros.
I have not found another solution in the current threads.
Thank you

Also, I have tried resetting the menus with this code found on the Forum:

Sub ResetMenus2()
With Application
.CommandBars("Worksheet Menu Bar").Controls("Tools").Enabled = True
.CommandBars("Worksheet Menu Bar").Controls("Edit").Enabled = True
.CommandBars("Worksheet Menu Bar").Controls("Insert").Enabled = True
.CommandBars("Tools").Enabled = True
.CommandBars("Edit").Enabled = True
.CommandBars("Insert").Enabled = True
.CommandBars("Ply").Enabled = True
.CommandBars("cell").Enabled = True
.CommandBars("Toolbar list").Enabled = True
.CommandBars.DisableCustomize = False
End With
End Sub

**xlnitwit** · 07-12-2016, 11:45 AM

Hi,

What is the result of pressing Shift+f11, or clicking the new sheet button on the right hand side of the sheet tabs?

**jacteaux** · 07-12-2016, 11:53 AM

Neither will work. The + sign to insert a worksheet is greyed out.

**xlnitwit** · 07-12-2016, 12:00 PM

Are you sure that the workbook is not protected? That is the only way I am aware of that you can disable the new sheet button on the tabs.

**jacteaux** · 07-12-2016, 12:16 PM

Am I missing something?
2016-07-12_12-15-03.jpg

**xlnitwit** · 07-12-2016, 03:07 PM

The fact that the button is highlighted means the workbook is actually protected despite the button caption. A fairly grand UX fail.

**jacteaux** · 07-12-2016, 03:40 PM

Thank you xlinitwit. I didn't realize. My apologies if I wasted your time.

I had no idea it wouldn't say Unprotect.
I have copied the data to a new workbook since no macros will work for me to break the workbook protection.

Thank you for your time!