Enable New Sheet "+" at bottom of page.??

[DRave45]

Please help me figure out how to enable the Insert New sheet (The "+" sigh at the bottom of my workbook.) I am working with a file where I have added 9 sheets to date and have saved the workbook. Now I need to add one more sheet, however the ability to add new sheets has been disabled. No sheets/workbooks are protected. I am baffled! Please help! Thank you in advance!! I think I attached my workbook...

[TMS]

Something is password protected. I've just tried to open it in Excel on an iPad and it asks for a password.

[Greg M]

Hi there,

The workBOOK you posted is password-protected and therefore sheets cannot be added/deleted/renamed etc.

just unprotect the workbook (assuming that you know the password!) and all should be well.

Hope this helps.

Regards,

Greg M

[DRave45]

My Bad!! I remember protecting one sheet but did not think that I had protected the entire workbook...
Thanks for your help.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.