Forum Discussion
Cannot add a worksheet to my Excel spreadsheet
I haver all of a sudden lost the ability to add worksheets to my spreadsheet program. I am using macros that both protect and unprotect the sheets that are currently there, but I want to add another sheet, and the plus sign at the bottom is grayed out as well as the 'Insert Line' line when you do Home/Insert. I have looked and I cannot find the setting that controls the addition of worksheets. Any suggestions???
6 Replies
I solved it! The problem was in the Protect Workbook. I apparently clicked on it and then forgot I did. It does not respond with "Unprotect Workbook" like "Protect Sheet" does, so I did not know that my workbook was protected because I could work with the Sheets that were already in my file. I think this is a bug in Excel that should be fixed.
I am not a novice - I tried closing and reopening, and unprotecting and pouring over all the documentation I could find before I bothered you guys with this. I have worked in this area of Excel for over 30 years and have never seen this before. The solution is not obvious.
Sounds like you need to unprotect the workbook.
Close the workbook without saving it.
Then re-open the the workbook.
Tried that. Doesn't work.
Then close Excel and start again.
