I can't delete worksheet in excel -2007

[hkbhansali]

only delete option and unhide option in worksheet is greyed out and i can't delete the worksheet,
and i have tried the some possible solution like to check whether the workbook is protected
or not and whether there is any code written in VB editor after pressing Alt+F11, so if any further
solution is available to remove this problem than please provide me.

 

[Andrew Poulsom]

Welcome to MrExcel.

Are you absolutely certain that the workbook isn't protected?

 

[Jonmo1]

Sounds like the book 'structure' is protected.
This is different from worksheet protection.

It's found in the same place as "Protect Sheet", but it's called "Protect workbook structure"

 

[hkbhansali]

yes, i am sure that the workbook isn't protected.

 

[Andrew Poulsom]

Do you want to put your workbook on a share like Box.com so that we can take a look?

 

[hkbhansali]

yes i can, please tell me where i have to share

 

[Andrew Poulsom]

You can use Box.com.

 

[hkbhansali]

i have share file - https://app.box.com/s/uchkb7e9pxvgj3rg3768

 

[Andrew Poulsom]

You can't delete the only sheet in a workbook.

 

[hkbhansali]

i have add sheets ,now u can check.pls link is https://app.box.com/s/uchkb7e9pxvgj3rg3768